|
Thank you.
Can you do in place editing of List Box Items?
|
|
|
|
|
Hi!!
I have a call to my data access class and I do it like this (from my displayNews.aspx page:
News objNews = NewsDA.GetNewsDetails(m_iNewsID);
m_iNewsID is the id number which I got from the query string
And my GetNewsDetails in my NewsDA class looks like this:
public static News GetNewsDetails(int intNewsID)
{
News objNews = new News();
// Create instance of connection and command object
SqlConnection objConn = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
SqlCommand objCmd = new SqlCommand("sp_GetNewsByID", objConn);
// Mark the command as a SPROC
objCmd.CommandType = CommandType.StoredProcedure;
// Add parameters to SPROC
SqlParameter paramNewsID = new SqlParameter("@NewsID", SqlDbType.Int, 4);
paramNewsID.Value = intNewsID;
objCmd.Parameters.Add(paramNewsID);
// Execute the statement
try
{
objConn.Open();
SqlDataReader objDr = objCmd.ExecuteReader();
try
{
while (objDr.Read())
{
objNews.NewsID = Convert.ToInt32(objDr["PKNewsID"]);
objNews.CategoryID = Globals.CheckDBIntForDBNulls(objDr["FKNewsCategoryID"]);
objNews.Title = objDr["NewsTitle"].ToString();
}
}
finally
{
if(!objDr.IsClosed)
{
objDr.Close();
}
}
}
finally
{
if(objConn.State == ConnectionState.Open)
{
objConn.Close();
}
objConn.Dispose();
objCmd.Dispose();
}
// Return the news object
return objNews;
}
If no records are found, then I should probably set objNews to null?? And the where I call this function, then I should probably test if the news object is equal to null?? I was thinking of putting in an if statement there in the second try block, if the dataset has rows, then do the while statement, otherwise set the objNews = null??
Please can some one advise. If there is a better way of testing if an object of News has any records (rows) in it, please let me know.
Regards,
ma se
|
|
|
|
|
Use a DataAdapter to fill a Datatable/Dataset.
xacc-ide 0.0.99-preview7 now with C#, C, C++, IL, XML, Nemerle, IronPython, Perl, Caml, SML, Ruby, Flex, Yacc, Java, Javascript, Lua, Prolog and Boo highlighting support!
|
|
|
|
|
Yes, but I am not returning a lot of records, just one based on the ID, so won't the data reader be the best way?
If I were to use the data reader, where and how would I test if any records were found?
|
|
|
|
|
If you are going to put the data into your business object (News) then I do not suggest using a SqlDataAdapter to fill a DataTable/DataSet because all you are going is wasting time creating extra copies of the data that you will throw away. (The SqlDataAdapter uses a SqlDataReader internally to populate the DataTable/DataSet)
You could look at the SqlDataReader.HasRows[^] property.
At the top of your method replace
News objNews = new News(); with
News objNews = null; . Wait until you perform the ExecuteReader() then, inside your try block (replacing the while loop), do something like this:
if (objDr.HasRows)
{
objNews = new News();
objDr.Read()
objNews.NewsID = Convert.ToInt32(objDr["PKNewsID"]);
objNews.CategoryID = Globals.CheckDBIntForDBNulls(objDr["FKNewsCategoryID"]);
objNews.Title = objDr["NewsTitle"].ToString();
}I took out the while because it wasn't really doing anything useful. If you expect only one row to be returned then the above will be fine. If you expect more than one row returned and you are just looking for the results of the last row then your old while loop will work, but it suggests there is something wrong with the SQL that it is returning more than it should.
Now, if no rows are returned from SQL Server, a null is returned from the method.
Does this help?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
Hi..
Im doing a user interface using C# web application program. When i add a new user to database, after adding it goes to the next page and i can choose to edit and confirm add user.. But my problem here is if i wanted to edit i created a edit button and goes to my previous page. How can i maintain the previos page particulars?? Coz i have tried clicking it and when it return to the previous page the particulars i fill in has lost.. Thankz.. =)
Smile alwyz =p
|
|
|
|
|
You can't maintain state between pages without using session variables, and you should avoid it. Instead, pass a parameter on the URL which your page then uses to restore it's state from the database.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
How collections (Queue/Stack/Hashtable...) store complex object?
Do they store object reference or object gets serialize?
Appreciate your help.
- ashish
|
|
|
|
|
I'm pretty sure they just store a reference to the object, I know that types such as int get boxed to be stored in a C# 1.1 container.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
It means if I dispose the object instance, the reference in Queue will return false values
Is there any way I can store the full object?
- ashish
|
|
|
|
|
AshishBasran wrote: It means if I dispose the object instance, the reference in Queue will return false values
Of course. No different to a vector in C++, if you store a pointer, don't delete it elsewhere.
AshishBasran wrote: Is there any way I can store the full object?
Don't dispose of stuff you want to keep. I don't see the problem here.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Depends on what you store in the collection. Value types (structs and other primitive data types except string) get boxed, which implicitly creates a copy of the original object. Reference types (classes) are stored by reference.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
Hi, This is Deepak. Friends I need you help. I just want to open the View Source Code of a HTML File through C# Code. Please Help me ASAP.
Deepak
|
|
|
|
|
Open your HTML file as text should give you the source code.
Cheers!!!!
- ashish
|
|
|
|
|
Hi
I have an application that has many different forms. All these forms use a certain kind of a TreeView that has drag/drop rules, copy/paste rules and other functionalities. I'm trying to create one inherited TreeView control instead of doing this for every TreeView in my application. Where do I start? How do I go about accomplishing that?
Thank you for your help.
|
|
|
|
|
i think you can build a usercontrol, that ok.;)
|
|
|
|
|
hi, I have a question.
I want to draw a line on the panel but this line must be drawn above all the control in this panel.
my code doesn't work as my want.
protected override void OnPaint(PaintEventArgs e)
{
base.OnPaint (e);
Graphics g = e.Graphics;
g.DrawRectangle(new Pen(Color.Red,3),0,0,this.Width-10,this.Height-10);
//this rectange still draws under all control
}
thanks for help!
|
|
|
|
|
Any control on your panel will draw above the panel. If this were not so, then you wouldn't be able to see your controls at all.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
so like you say, how can i put a frame(drawing image) may be this image on another or same panel which  is displaying images that are capturing by webcam.
sorry about my bad English!
-- modified at 0:16 Wednesday 26th October, 2005
|
|
|
|
|
Are you doing this in the FORM's on paint, or a control's (what is this)? the co-ordinates you specify should draw the rectangle positionned at the top left of this and 10 pix smaller than the control's size - i.i the top left corner of the rectangle will be at the same point as the top left corner of the control's client area, with it's bottom right corner 10 pix in from this's botoom right corner...
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
my panel still has alot controls and i want this rectangle draw above these controls,and i have just done it buy set the BackColor=Color.Transparency;
but while my panel display images capture by webcam, this doesn't qork anymore?
Sorry about my bad English!
thanks for your help!
|
|
|
|
|
Hi there,
i try this in my code but some problem in the updated stmt can u help me shoot wht the problem is the compiler thro me error: The name Var1 does not exist in the class or namespace of the project....
here is the codesnippet:
string strsql;
DataTable dt;
SqlDataAdapter da;
SqlConnection objConn = new SqlConnection("data source=yusuff;user id=sa;password=sa;initial catalog=Heritage");
dt = new DataTable();
strsql = "select * from Articles_production";
da = new SqlDataAdapter(strsql,objConn);
da.Fill(dt);
if(dt.Rows.Count > 0)
{
//foreach (DataRow dr in dt.Rows) //ervy loop
for (int i=0;i
|
|
|
|
|
If your code looks the way that it is posted. the for loop is incomplete.
|
|
|
|
|
no i posted my codesnippet as
For (int i=0;i
|
|
|
|
|
ur text box is truncate the code...pls check the code project page
regards
ybasha
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
