C# Discussion Boards - CodeProject

Re: trapping events in downlaod dialog box in asp.net with c#

9-Aug-04 4:33

Try the ASP.Net forum

Kev Pearman MCP

ashu_sharma219-Aug-04 18:05

ashu_sharma21

9-Aug-04 18:05

Thnx mate..

I have posted this problem on ASP.NET but still i would be very gr8ful to if you people could guide me a little in this regard..

Cheers
Ashu

System Informtion

Member 12302189-Aug-04 2:39

Member 1230218

9-Aug-04 2:39

How to get the "CPU Serial Number", "CPU Model Type", "Amount of RAM", "Video Controller ID" and "SCSI ID" using c#

P.Chandramohan

Re: System Informtion

leppie9-Aug-04 3:26

leppie

9-Aug-04 3:26

P.Chandramohan wrote:
CPU Serial Number

Thats only an optional P3 feature, thats off by default.

Most other info you can probably get thru System.Management and WMI. You have to refer to the MSDN WMI docs for more info (note: they are well hidden!).

^{top secret xacc-ide 0.0.1}

Re: System Informtion

Nick Parker9-Aug-04 3:32

Nick Parker

9-Aug-04 3:32

Read the following article: Windows Management Instrumentation (WMI) Implementation[^]

- Nick Parker
My Blog | My Articles

Re: System Informtion

Stefan Troschuetz9-Aug-04 5:30

Stefan Troschuetz

9-Aug-04 5:30

A useful article[^] from MSDN magazine about usage of WMI, which was already mentioned as solution for your problem.

www.troschuetz.de

Csharp , MySQLDriverCS + dataGrid

Nekosan9-Aug-04 2:28

9-Aug-04 2:28

Ok here is the question, Im useing Mysqldrivercs and ive got a dataSet with a table thats populated already, the same way on my Mysql server.. but I cant seem to get the data from the mysql server to load into my datagrid's dataset.. anyone have this problem? or have a sample code for it?

Thanks Smile | :)

exhaulted9-Aug-04 3:34

9-Aug-04 3:34

Post some code, show us how you are updating the database and hopefully someone can point you in the right direction. Personally i would use a SqlDataAdapter to update the database from the dataset.

DataSet ds = new DataSet();<br />
System.Data.SqlClient.SqlDataAdapter sql = new System.Data.SqlClient.SqlDataAdapter();<br />
sql.Update(ds);

If thats not what you're trying to do then post a bit more info.

Cheers

Kev Pearman MCP

Nekosan9-Aug-04 3:57

9-Aug-04 3:57

MySQLDataAdapter da = new MySQLDataAdapter();
MySQLConnection con = new MySQLConnection();
con = new MySQLConnection(new MySQLConnectionString(ip,
dbname,
username,
password).AsString);

con.Open();
MySQLCommand sql = new MySQLCommand("SELECT * FROM `character`",con);

MySQLDataReader reader = sql.ExecuteReaderEx();
if(reader.Read())
{
conn.Text = "Yes";
while(reader.Read())
{
}
}
reader.Close();
sql.Dispose();
con.Close();
}
where its while(reader.Read())
{
}
Ive put da.Fill(ds);
but thats not what I need.

exhaulted9-Aug-04 4:22

9-Aug-04 4:22

To write back to the database use da.Update(ds);
da.Fill fills a dataset, if i understand what you are asking for you want to update the database from the dataset, this is where the .Update command comes in.

Kev Pearman MCP

Nekosan9-Aug-04 4:34

9-Aug-04 4:34

thanks yeah I do want to have an update but thats a differnt story Smile | :)

Right now im trying to get it to load the data from my sql server to my client's dataset table.

exhaulted9-Aug-04 4:57

9-Aug-04 4:57

OK, sorry i guess i got the wrong end of the stick there Smile | :)

You said in your previous post that da.Fill(DataSet) doesn't work.
This is how i would fill a DataSet from a DataAdapter, why is the Fill method not OK for yourself?

Kev Pearman MCP

Nekosan9-Aug-04 5:29

9-Aug-04 5:29

Now I get an error:

System.InvalidOperationException: The SelectCommand property has not been initialized before calling 'Fill'.
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

exhaulted9-Aug-04 22:25

9-Aug-04 22:25

You have to write the Select command for the data adapter so it knows what fields to pull out of the database. If you are using Visual Studio then just drag and drop a DataAdapter onto you form and it wil open a wizard. Follow the prompts and the select command will be created for you along with Update, Delete and Insert statements, as long as you specify the primary key for your data.

If you are not using visual studio then you will have to create the SQL statements for selecting and updating the data required and assign them to the relevant properties of your DataAdapter

Kev Pearman MCP

Nekosan10-Aug-04 9:29

10-Aug-04 9:29

Im useing VS .NET 7.1, I didnt get a wizard when I did that, but it did put the adapter there.. is there a howto on setting up these commands properly?
Thanks

exhaulted10-Aug-04 21:35

10-Aug-04 21:35

I'm sure there's plenty of info out there about setting up the command properties of a DataAdapter but i really couldn't tell you where. Try MSDN or search the forums for something.

If that doesn't work then try reposting at the front of the forums and ask specifically for help on setting up DataAdapters Command properties, i'm sure someone will have a link to a document you could use.

Kev Pearman MCP

Nekosan14-Aug-04 23:51