|
Have a read of this article. It explains simply, and step by step, how to insert and read data from a SQL server. Its the one I used when I was figuring it out.
Cheers,
Mark.
|
|
|
|
|
cmd.Connection = con;
cmd.CommandText = "select * from contact";
da.SelectCommand = cmd;
DataTable dtable = new DataTable();
DataSet ds2 = new DataSet();
da.Fill(ds2);
dtable = ds2.Tables[0];
// Create an array to multiple values at once.
string[,] saNames = new string[5, 2];
saNames[0, 0] = dtable.Rows[0].ItemArray[1].ToString();
saNames[0, 1] = dtable.Rows[0].ItemArray[2].ToString();
saNames[1, 0] = dtable.Rows[0].ItemArray[3].ToString();
saNames[1, 1] = dtable.Rows[0].ItemArray[4].ToString();
saNames[2, 0] = dtable.Rows[0].ItemArray[5].ToString();
saNames[2, 1] = dtable.Rows[0].ItemArray[6].ToString();
saNames[3, 0] = dtable.Rows[0].ItemArray[7].ToString();
saNames[3, 1] = dtable.Rows[0].ItemArray[8].ToString();
saNames[4, 0] = dtable.Rows[0].ItemArray[9].ToString();
saNames[4, 1] = dtable.Rows[0].ItemArray[10].ToString();
the above is based on one row data..
how if my database has many rows of data ??
i want to put a while loop there.
also the saNames[0, 0] ..saNames[4, 1].. data which exported arrange weird.. not fooolow the sequence..
modified on Monday, January 07, 2008 11:34:08 PM
|
|
|
|
|
How is it possible to clear the cookies a webbrowser component set?
|
|
|
|
|
Hi,
on WinXP cookies are regular files located in a folder such as
C:\Documents and Settings\MyName\Cookies\
To get the path of that folder, use
Environment.GetFolderPath(Environment.SpecialFolder.Cookies)
|
|
|
|
|
So I have to do it via the file system. I had hoped there would be an easier way because every Windows version stores them in a different directory. 
|
|
|
|
|
I think I have shown you the way to get to the folder, no matter what Windows version you have.
|
|
|
|
|
hi
i made program in VS2008 with Framework 3.5
and i sow that it canot work on win 2000.
what can i do ?
thanks
|
|
|
|
|
Have you installed the .NET Framework v3.5 on that computer? It looks like .NET Framework 3.0 and later no longer have support for Windows 2000, so you'll need to compile this against the Framework 2.0.
Scott.
—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[ Forum Guidelines] [ Articles] [ Blog]
modified on Sunday, January 06, 2008 3:46:58 PM
|
|
|
|
|
Is it even possible to run the .NET 3.5 Framework on a Windows 2000 machine? I know VS2008 won't work, but I am curious about just the .NET 3.5 runtime.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
I think you're right Paul. I just double-checked and it does appear that .NET Framework 3.0 and 3.5 no longer have support for Windows 2000.
Scott.
—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[ Forum Guidelines] [ Articles] [ Blog]
|
|
|
|
|
Scott Dorman wrote: I just double-checked and it does appear that .NET Framework 3.0 and 3.5 no longer have support for Windows 2000
I wasn't too sure. I guess it may be time soon to upgrade all of my Virtual PC boxes 
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
i try to install framework 3.5 on 2000, but it cant be install.
it wright that not sopport , what can i do ?
|
|
|
|
|
See the update [^] to my earlier response. You'll need to target the .NET Framework 2.0.
Scott.
—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[ Forum Guidelines] [ Articles] [ Blog]
|
|
|
|
|
If you are stuck with having to support Windows 2000 in your app, you'll need to stick with .NET 2.0. If it is a requirement to utilize .NET 3.5 in your app, then there isn't much you can do for the Windows 2000 users. They'll need to upgrade whether they like it or not.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
As has been said you will have to target .NET 2.0.
However, they have said that Silverlight specifically will eventually be available for Windows 2000 and that is a subset of .NET 3.5 (there's a graphic somewhere on the web showing this).
Kevin
|
|
|
|
|
Kevin McFarlane wrote: However, they have said that Silverlight specifically will eventually be available for Windows 2000 and that is a subset of .NET 3.5
Yes, I have seen the same thing although I can only find some forum posts (here[^] and here[^]) that confirm this is the case.
Scott.
—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[ Forum Guidelines] [ Articles] [ Blog]
|
|
|
|
|
hi.. i use c# wpf blend..
i cant do the menuitem in wpf project like what i did in vs where the designer will handle the thing for me..
how should i display drop down in my menu ?? e.g. file.. save.. open...
|
|
|
|
|
You have to go into the Collection Editor for the menu items and take it from there.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
thansk for the reply...
i still do not get menu dropdown done through c# wpf project..
hope can get some samplecode here. thanks
|
|
|
|
|
Look around at Josh Smith's articles on WPF around here. He might have something on it ( I'm not sure but it seems like he's done 15-20 articles on WPF ).
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
hi
so far see that when u execute this command in sql server 2005 :
select * from Sales.SalesOrderDetail
result set display result immediately and loading continue until all data load.
(the elapsed time to load all records [121317 records] is 3-4 seconds)
but when i use BeginExecuteReader in my app, my app did not display result set immediately and wait until all records load and then display result, how to i execute like sql server that display result set immediately and don't wait until all data load ?
thanks
|
|
|
|
|
it's a tad worrying that you want to display 121317 records to the user in one go. Can they really assimilate that quantity of data?
To get a faster response time to your user, page the data. Go get a 100 records, display them, then go get 100 more.
Small angry dogs
|
|
|
|
|
thanks for reply
my question is how to sql server implement this technique for display loaded data and loading other data at the same time ?
thanks
|
|
|
|
|
Hi,
I'm using a property grid to update some settings that are stored in my database.
PropertiesControl.OnPropertyValueChanged; 'CurrentDirectory' has been changed.<br />
SqlStatements.Update; Formatted SQL == UPDATE MetaData SET Value = '/sadasd' WHERE Name = 'CurrentDirectory';<br />
DbConnection.ExecuteNonQuery; Performing SQL.<br />
DbConnection.OnStateChange; Connection State Change: Open<br />
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll<br />
DbConnection.ExecuteNonQuery; Exception: System.Data.OleDb.OleDbException: Syntax error in UPDATE statement.<br />
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)<br />
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)<br />
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)<br />
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)<br />
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()<br />
at UNet.Server.Database.DbConnection.ExecuteNonQuery(String sql) in D:\DbConnection.cs:line 153<br />
DbConnection.OnStateChange; Connection State Change: Closed
I cant see whats wrong. The table is correct, both the values are strings and the sql seems fine to me.
Any ideas?
Regards,
Gareth
|
|
|
|
|
Is MetaData a keyword? Should it be surrounded with [] or something? Maybe you should choose a different name for your table?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
