I have written the code as below. here problem is that dt remain null. how to solve thst please tell me. public partial class Form1 : Form { private DataTable DTable; private DataRow drow; public Form1() { InitializeComponent(); } private OleDbConnection getConnection() { OleDbConnection con=new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\winApp for Student\winApp for Student\App_Data\SchooMgnSystem.mdb;Persist Security Info=True"); return con; } private void button1_Click(object sender, EventArgs e) { InsertData(); } private void InsertData() { if (DTable==null) { DTable = new DataTable(); DTable.Columns.Add("StudID", typeof(string)); DTable.Columns.Add("StudName", typeof (string)); DTable.Columns.Add("Address", typeof(string)); drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } else { drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } } private void button2_Click(object sender, EventArgs e) { string cmdstr; OleDbCommand cmd; OleDbConnection con = getConnection(); foreach (DataRow Drow in DTable.Rows) { cmdstr = "Insert into Student values('" + drow[0].ToString() + "','" + drow[1].ToString() + "','"+drow [2].ToString()+"')"; cmd = new OleDbCommand(cmdstr,con); try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } } }

2651

What is Mutex error in Triggers?

3071

ORA-26076: cannot set or reset value after direct path structure is allocated

1970

ORA-26094: stream format error: input column overflow

2809

mount: mount to NFS server failed: System Error: Connection timed out

3668

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2807

NZE-28890: Entrust Login Failed

1882

ORA-16626: failed to enable specified object

2219

IMG-02003: 2FF03 - incorrect color histogram feature specification

1710

ORA-26084: direct path context already finished

1950

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1620

What is live lock, deadlock and what is Lock escalation?

2434

ORA-26028: index string.string initially in unusable state

3864

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1683

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2707