Click here to Skip to main content
15,924,367 members
Home / Discussions / C#
   

C#

 
Questionhow to save visual component Pin
puttaraj13-Dec-06 0:48
puttaraj13-Dec-06 0:48 
AnswerRe: how to save visual component Pin
stancrm13-Dec-06 1:31
stancrm13-Dec-06 1:31 
GeneralRe: how to save visual component Pin
puttaraj13-Dec-06 20:13
puttaraj13-Dec-06 20:13 
QuestionSql Question : Can i use DataRows Instead of Sql Transactions ? [modified] Pin
hdv21213-Dec-06 0:30
hdv21213-Dec-06 0:30 
AnswerRe: Sql Question : Can i use DataRows Instead of Sql Transactions ? Pin
J4amieC13-Dec-06 1:02
J4amieC13-Dec-06 1:02 
GeneralRe: Sql Question : Can i use DataRows Instead of Sql Transactions ? Pin
hdv21213-Dec-06 1:08
hdv21213-Dec-06 1:08 
GeneralRe: Sql Question : Can i use DataRows Instead of Sql Transactions ? Pin
J4amieC13-Dec-06 1:26
J4amieC13-Dec-06 1:26 
AnswerRe: Sql Question : Can i use DataRows Instead of Sql Transactions ? Pin
lost in transition 13-Dec-06 4:08
lost in transition 13-Dec-06 4:08 
You have the right idea you are just implementing it wrong.
Look at this code:

case "Microsoft.Jet.OLEDB.4.0":
OleDbConnection OleConn = new OleDbConnection(_ConnString);
OleDbDataAdapter OleAdp = new OleDbDataAdapter(InsertString, OleConn);

OleAdp.InsertCommand = new OleDbCommand(SQL.BuildHourlySQL());
OleAdp.InsertCommand.Parameters.Add("@RecID", OleDbType.Integer, 50, "RecID");
OleAdp.InsertCommand.Parameters.Add("@DSID", OleDbType.Integer, 50, "DSID");
OleAdp.InsertCommand.Parameters.Add("@Month", OleDbType.Integer, 50, "Month");
OleAdp.InsertCommand.Parameters.Add("@Day", OleDbType.Integer, 50, "Day");
OleAdp.InsertCommand.Parameters.Add("@Year", OleDbType.Integer, 50, "Year");
OleAdp.InsertCommand.Parameters.Add("@Hour", OleDbType.Integer, 50, "Hour");
OleAdp.InsertCommand.Parameters.Add("@KW", OleDbType.VarChar, 50, "KW");
OleAdp.InsertCommand.Parameters.Add("@KVAR", OleDbType.VarChar, 50, "KVAR");
OleAdp.InsertCommand.Parameters.Add("@CAP", OleDbType.VarChar, 50, "CAP");
OleAdp.InsertCommand.Connection = OleConn;

OleConn.Open();
OleAdp.Update(_HourlyData);
didUp = true;
OleConn.Close();
return _HourlyData;
break;

In a differnt part of your code this is where you use the Datarow:

DataRow _dr = _HourlyData.NewRow();
_dr["RecID"] = _RTm.RecID;
_dr["DSID"] = _RTm.DataSetID;
_dr["Month"] = _RTm.Month;
_dr["Day"] = _RTm.Day;
_dr["Year"] = _RTm.Year;
_dr["Hour"] = _RTm.Hour;
_dr["KW"] = _HrData.RA_Tot;
_dr["KVAR"] = _HrData.RB_Tot;
_dr["CAP"] = _HrData.RC_Tot;
_HourlyData.Rows.Add(_dr);



Programmer: A biological machine designed to convert caffeine into code. * Developer: A person who develops working systems by writing and using software.
[^]

Questioni have a probleam in C# window Service Pin
Sanjib Raj13-Dec-06 0:21
Sanjib Raj13-Dec-06 0:21 
AnswerRe: i have a probleam in C# window Service Pin
Colin Angus Mackay13-Dec-06 0:48
Colin Angus Mackay13-Dec-06 0:48 
Questionswitch content of a panel Pin
Marc Soleda12-Dec-06 23:41
Marc Soleda12-Dec-06 23:41 
AnswerRe: switch content of a panel Pin
quiteSmart13-Dec-06 1:43
quiteSmart13-Dec-06 1:43 
GeneralRe: switch content of a panel Pin
Marc Soleda13-Dec-06 1:57
Marc Soleda13-Dec-06 1:57 
AnswerRe: switch content of a panel Pin
Not Active13-Dec-06 2:19
mentorNot Active13-Dec-06 2:19 
QuestionSave textbox in sqlserver2000 Pin
hadio12-Dec-06 21:55
hadio12-Dec-06 21:55 
AnswerRe: Save textbox in sqlserver2000 Pin
Pete O'Hanlon12-Dec-06 22:36
mvePete O'Hanlon12-Dec-06 22:36 
Questioncall javascript function from c# code without based on event Pin
ALAQUNAIBI12-Dec-06 21:42
ALAQUNAIBI12-Dec-06 21:42 
AnswerRe: call javascript function from c# code without based on event Pin
il_masacratore12-Dec-06 21:49
il_masacratore12-Dec-06 21:49 
GeneralRe: call javascript function from c# code without based on event Pin
ALAQUNAIBI17-Dec-06 0:40
ALAQUNAIBI17-Dec-06 0:40 
QuestionWhy property or field unable to give the contents ? Pin
kalaveer12-Dec-06 19:49
kalaveer12-Dec-06 19:49 
AnswerRe: Why property or field unable to give the contents ? Pin
chravisankar12-Dec-06 20:23
chravisankar12-Dec-06 20:23 
GeneralRe: Why property or field unable to give the contents ? Pin
kalaveer12-Dec-06 21:04
kalaveer12-Dec-06 21:04 
AnswerRe: Why property or field unable to give the contents ? Pin
Guffa12-Dec-06 21:00
Guffa12-Dec-06 21:00 
AnswerRe: Why property or field unable to give the contents ? Pin
J4amieC12-Dec-06 22:23
J4amieC12-Dec-06 22:23 
GeneralRe: Why property or field unable to give the contents ? Pin
kalaveer12-Dec-06 23:07
kalaveer12-Dec-06 23:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.