adding data

[Selen]

Hello,
I add my data from sqlserver to dropdownlist on formload.I wanted it doesnt
load data every time on form load.I made if session is null then load if
session isnt null dont load.I add to sqlserver a new data ans I make session
is null.But in dropdownlist I coudnt see my new data.I use below code for
adding.I make logic error. Is Using Session logic true? or I have to refresh
sql data if so how can I do this...
SqlConnection conn=new SqlConnection ();

conn.Connection String
="server=(local )\\sql2000;data base=db_Kalite_ Data;uid=sa;pwd =antalya";

SqlCommand cmd=new SqlCommand ();

cmd.Connection =conn;

string str="insert ............... .........";

cmd.CommandText =str;

conn.Open ();

cmd.ExecuteNonQ uery ();

conn.Close ();

Thanks...

[Ignacio Machin \( .NET/ C# MVP \)]

Hi selen,

If you insert new data on the DB you will have to refresh the one kept in
session, following your logic you can set the session variable holding the
data to null, in this form the next time the data is needed it will be
loaded as it would be the first time that you run the application.
Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Selen" <sk*****@yahoo. com> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. .

Hello,
I add my data from sqlserver to dropdownlist on formload.I wanted it doesnt load data every time on form load.I made if session is null then load if
session isnt null dont load.I add to sqlserver a new data ans I make session is null.But in dropdownlist I coudnt see my new data.I use below code for
adding.I make logic error. Is Using Session logic true? or I have to refresh sql data if so how can I do this...
SqlConnection conn=new SqlConnection ();

conn.Connection String
="server=(local )\\sql2000;data base=db_Kalite_ Data;uid=sa;pwd =antalya";

SqlCommand cmd=new SqlCommand ();

cmd.Connection =conn;

string str="insert ............... .........";

cmd.CommandText =str;

conn.Open ();

cmd.ExecuteNonQ uery ();

conn.Close ();

Thanks...