C# ADO.NET console application

[krukinews]

Hi,
I'm trying to write small program (console application) that reads from
Event Log end writes data to SQL Server. I'm new to C# and ADO.NET and
for last 3 days I have read many tutorials and I think that I
understand basic (only basic) concepts of ADO.NET.

But I simple can't create console application that uses Master Detail
concept.

Table structure (keys only).
tblServer
ID_Server (auto inc)

tblEventLogs
ID_EventLog (auto inc)
ID_Server

tblEventLogEntr ies
ID_EventLogEntr y (auto inc)
ID_EventLog

//my code

public static SqlDataAdapter CreateDataAdapt er(string selectSQL,
SqlConnection conn) {
SqlDataAdapter da = new SqlDataAdapter( );
da.SelectComman d = new SqlCommand(sele ctSQL, conn);

SqlCommandBuild er cb = new SqlCommandBuild er(da);

da.InsertComman d = cb.GetInsertCom mand();
da.UpdateComman d = cb.GetUpdateCom mand();
da.DeleteComman d = cb.GetDeleteCom mand();

return da;
}

SqlConnection connMain = new
SqlConnection(" server=server;u id=uid;pwd=pws; database=databa se;");
connMain.Open() ;

SqlDataAdapter daServers = CreateDataAdapt er("SELECT * FROM
tblServers", connMain);
SqlDataAdapter daEventLogs = CreateDataAdapt er("SELECT * FROM
tblEventLogs", connMain);
SqlDataAdapter daEventLogEntri es = CreateDataAdapt er("SELECT * FROM
tblEventLogEntr ies", connMain);

DataSet dsMain = new DataSet();

daServers.FillS chema(dsMain, SchemaType.Sour ce, "tblServers ");
daEventLogs.Fil lSchema(dsMain, SchemaType.Sour ce, "tblEventLogs") ;
daEventLogEntri es.FillSchema(d sMain, SchemaType.Sour ce,
"tblEventLogEnt ries");

daServers.Fill( dsMain, "tblServers ");
daEventLogs.Fil l(dsMain, "tblEventLogs") ;
daEventLogEntri es.Fill(dsMain, "tblEventLogEnt ries");

dsMain.Tables["tblServers "].DefaultView.So rt = "ServerName ";
dsMain.Tables["tblEventLo gs"].DefaultView.So rt = "ID_Server,LogN ame";

//my implementation of Current record (any better idea?)
DataRow rowServer;
DataRow rowEventLog;

int tmp =
dsMain.Tables["tblServers "].DefaultView.Fi nd(strComputerN ame);

if (tmp < 0) {
rowServer = dsMain.Tables["tblServers "].NewRow();
rowServer["ServerName "] = strComputerName ;
dsMain.Tables["tblServers "].Rows.Add(rowSe rver);
daServers.Updat e(dsMain, "tblServers ");
} else {
rowServer = dsMain.Tables["tblServers "].Rows[tmp];
}

Problem is that I need ID_Server of new record to create records in
tbl_EventLogs but rowServer["ID_Server"] of new record is always 0. I
think that this has to do something with diconnected record set (or
not).

Any sugestions are welcome.
Mihalic Krunoslav

[Nicholas Paldino [.NET/C# MVP]]

Mihalic,

Once you have the structure of the data in your data set, create
DataRelation instances that link the parent and the child tables correctly.
If you do this correctly, then when you run the tables through the data
adapter for update, it should detect the relations, and get the appropriate
id of the parent.

Hope this helps.

<kr*******@gmai l.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

Hi,
I'm trying to write small program (console application) that reads from
Event Log end writes data to SQL Server. I'm new to C# and ADO.NET and
for last 3 days I have read many tutorials and I think that I
understand basic (only basic) concepts of ADO.NET.

But I simple can't create console application that uses Master Detail
concept.

Table structure (keys only).
tblServer
ID_Server (auto inc)

tblEventLogs
ID_EventLog (auto inc)
ID_Server

tblEventLogEntr ies
ID_EventLogEntr y (auto inc)
ID_EventLog

//my code

public static SqlDataAdapter CreateDataAdapt er(string selectSQL,
SqlConnection conn) {
SqlDataAdapter da = new SqlDataAdapter( );
da.SelectComman d = new SqlCommand(sele ctSQL, conn);

SqlCommandBuild er cb = new SqlCommandBuild er(da);

da.InsertComman d = cb.GetInsertCom mand();
da.UpdateComman d = cb.GetUpdateCom mand();
da.DeleteComman d = cb.GetDeleteCom mand();

return da;
}

SqlConnection connMain = new
SqlConnection(" server=server;u id=uid;pwd=pws; database=databa se;");
connMain.Open() ;

SqlDataAdapter daServers = CreateDataAdapt er("SELECT * FROM
tblServers", connMain);
SqlDataAdapter daEventLogs = CreateDataAdapt er("SELECT * FROM
tblEventLogs", connMain);
SqlDataAdapter daEventLogEntri es = CreateDataAdapt er("SELECT * FROM
tblEventLogEntr ies", connMain);

DataSet dsMain = new DataSet();

daServers.FillS chema(dsMain, SchemaType.Sour ce, "tblServers ");
daEventLogs.Fil lSchema(dsMain, SchemaType.Sour ce, "tblEventLogs") ;
daEventLogEntri es.FillSchema(d sMain, SchemaType.Sour ce,
"tblEventLogEnt ries");

daServers.Fill( dsMain, "tblServers ");
daEventLogs.Fil l(dsMain, "tblEventLogs") ;
daEventLogEntri es.Fill(dsMain, "tblEventLogEnt ries");

dsMain.Tables["tblServers "].DefaultView.So rt = "ServerName ";
dsMain.Tables["tblEventLo gs"].DefaultView.So rt = "ID_Server,LogN ame";

//my implementation of Current record (any better idea?)
DataRow rowServer;
DataRow rowEventLog;

int tmp =
dsMain.Tables["tblServers "].DefaultView.Fi nd(strComputerN ame);

if (tmp < 0) {
rowServer = dsMain.Tables["tblServers "].NewRow();
rowServer["ServerName "] = strComputerName ;
dsMain.Tables["tblServers "].Rows.Add(rowSe rver);
daServers.Updat e(dsMain, "tblServers ");
} else {
rowServer = dsMain.Tables["tblServers "].Rows[tmp];
}

Problem is that I need ID_Server of new record to create records in
tbl_EventLogs but rowServer["ID_Server"] of new record is always 0. I
think that this has to do something with diconnected record set (or
not).

Any sugestions are welcome.
Mihalic Krunoslav

[Victor Pereira]

Please.. use try and catch, to catch all exceptions, and protect your code.

Reguards,

Victor
<kr*******@gmai l.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

Hi,
I'm trying to write small program (console application) that reads from
Event Log end writes data to SQL Server. I'm new to C# and ADO.NET and
for last 3 days I have read many tutorials and I think that I
understand basic (only basic) concepts of ADO.NET.

But I simple can't create console application that uses Master Detail
concept.

Table structure (keys only).
tblServer
ID_Server (auto inc)

tblEventLogs
ID_EventLog (auto inc)
ID_Server

tblEventLogEntr ies
ID_EventLogEntr y (auto inc)
ID_EventLog

//my code

public static SqlDataAdapter CreateDataAdapt er(string selectSQL,
SqlConnection conn) {
SqlDataAdapter da = new SqlDataAdapter( );
da.SelectComman d = new SqlCommand(sele ctSQL, conn);

SqlCommandBuild er cb = new SqlCommandBuild er(da);

da.InsertComman d = cb.GetInsertCom mand();
da.UpdateComman d = cb.GetUpdateCom mand();
da.DeleteComman d = cb.GetDeleteCom mand();

return da;
}

SqlConnection connMain = new
SqlConnection(" server=server;u id=uid;pwd=pws; database=databa se;");
connMain.Open() ;

SqlDataAdapter daServers = CreateDataAdapt er("SELECT * FROM
tblServers", connMain);
SqlDataAdapter daEventLogs = CreateDataAdapt er("SELECT * FROM
tblEventLogs", connMain);
SqlDataAdapter daEventLogEntri es = CreateDataAdapt er("SELECT * FROM
tblEventLogEntr ies", connMain);

DataSet dsMain = new DataSet();

daServers.FillS chema(dsMain, SchemaType.Sour ce, "tblServers ");
daEventLogs.Fil lSchema(dsMain, SchemaType.Sour ce, "tblEventLogs") ;
daEventLogEntri es.FillSchema(d sMain, SchemaType.Sour ce,
"tblEventLogEnt ries");

daServers.Fill( dsMain, "tblServers ");
daEventLogs.Fil l(dsMain, "tblEventLogs") ;
daEventLogEntri es.Fill(dsMain, "tblEventLogEnt ries");

dsMain.Tables["tblServers "].DefaultView.So rt = "ServerName ";
dsMain.Tables["tblEventLo gs"].DefaultView.So rt = "ID_Server,LogN ame";

//my implementation of Current record (any better idea?)
DataRow rowServer;
DataRow rowEventLog;

int tmp =
dsMain.Tables["tblServers "].DefaultView.Fi nd(strComputerN ame);

if (tmp < 0) {
rowServer = dsMain.Tables["tblServers "].NewRow();
rowServer["ServerName "] = strComputerName ;
dsMain.Tables["tblServers "].Rows.Add(rowSe rver);
daServers.Updat e(dsMain, "tblServers ");
} else {
rowServer = dsMain.Tables["tblServers "].Rows[tmp];
}

Problem is that I need ID_Server of new record to create records in
tbl_EventLogs but rowServer["ID_Server"] of new record is always 0. I
think that this has to do something with diconnected record set (or
not).

Any sugestions are welcome.
Mihalic Krunoslav