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(); } } }

2660

who have build this website?

2282

during the rebate processing i got error that THE SALES VOLUME FOR AGREEMENT <101> IS NOT CURRENT.SO HOW TO RESOLVE THIS ISSUES?

3503

Answers for Complete This Song B_C_A_A _IL K_A KA_E, S__AN J__E B__D_ J__E

3235

what is the instrument that used in Mechanical Energy??

2693

If Fi account is assigned to cost element categorie poatings are not possible it is giving error that cost element has to be assigned to a co object whts the solution for this error?

2807

How will you Handle Error in SQL SERVER 2008?

2413

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2746

a pleasant evening. i would like to ask a question about yellow journalism. This is another term for sensationalism right? i just wanted to know a lot of articles or studies with regards to the effect this yellow journalism could effect the interpretation of the students,especially college students who are taking Communication course. please help me answer this.

2251

can u deactivate my music massage from mobily? some times i recharge my a/c then after sometimes one massage come and sr.4/- debited from my account. so please help me stop the massage about music or what. i don't know stop them please.from yesterday i have lose sr.8/- from my account.

2464

I have got one job selection order from DECON ENGG(HRD), he told me to send 2000 rs of demand draff i have send the demand draff after some time a got a job selection order in banglore but he have written that u have to give 550 rs of Guidency fees in bangalore i dont understant what to do

2619

A sample program using data structure? what is file handling?

3388

How to view the error log for any specific instance?

2494

How can be avoid the Error while being Human we do mistakes???

2604

Any body can tel me how to display a Frame Link of a page in Another Frame? For Clearance of my dought..... I designed a BSP page with 3 frames as shown below. -------------------------------- | | | Frame 1 | | | -------------------------------- | Frame 2 | Frame 3 | | | | | Link 1 | | | Link 2 | | | Link 3 | | | | | -------------------------------- Now in Frame 1 i displayed one page.. And in Frame 2 i displayed one page with some links. Now when i clicked on any Link in Frame 2 that corresponding Page has to display in Frame 3. In general HTML i know...But in BSP i don't know that much since i am new to this... plz any solutions...thanks a lot.... Regards, Shankar.

2409