TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
raz real
NA
86
3.9k
error in updating a database
Dec 6 2012 3:25 PM
i am new to ado.net and i have am having a problem in updating a database.
whenever i run the program an exception is raised.
error:uninitialized string
i have checked the connection string and every thing is fine .
i can navigate the records backward and forward
i can add data to the datased
but when i try to update data into the database then this exception error arises.
i searched every where but unable to find any solution ...
following code...
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication16
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
System.Data.SqlClient.SqlConnection con;
DataSet ds1;
System.Data.SqlClient.SqlDataAdapter da;
int MaxRows = 0;
int inc = 0;
private void Form1_Load(object sender, EventArgs e)
{
con = new System.Data.SqlClient.SqlConnection();
//(@"Data Source=\SQLEXPRESS;AttachDbFilename=F:\MyWorkers1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
con.ConnectionString = "Data Source=\\SQLEXPRESS;AttachDbFilename=F:\\MyWorkers1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
ds1 = new DataSet();
string sql = "SELECT * from tblWorkers";
da =new System.Data.SqlClient.SqlDataAdapter(sql, con);
con.Open();
da.Fill(ds1, "Workers");
NavigateRecords();
MaxRows = ds1.Tables["Workers"].Rows.Count;
MessageBox.Show("open");
con.Close();
MessageBox.Show("close");
con.Dispose();
}
private void NavigateRecords()
{
DataRow dRow = ds1.Tables["Workers"].Rows[inc];//dataset me jo data rakha hay wo
//text boxes medaldo
textBox1.Text = dRow.ItemArray.GetValue(1).ToString();
textBox2.Text = dRow.ItemArray.GetValue(2).ToString();
textBox3.Text = dRow.ItemArray.GetValue(3).ToString();
}
private void button1_Click(object sender, EventArgs e)
{
if (inc != MaxRows - 1)
{
inc++;
NavigateRecords();
}
else
{ MessageBox.Show("last record"); }
}
private void button2_Click(object sender, EventArgs e)
{
if (inc != 0)
{
inc--;
NavigateRecords();
}
else { MessageBox.Show("first row"); }
}
private void button3_Click(object sender, EventArgs e)
{
if (inc != MaxRows - 1)
{ inc = MaxRows - 1;
NavigateRecords();
}
}
private void button4_Click(object sender, EventArgs e)
{
if (inc != 0)
{ inc = 0;
NavigateRecords();
}
}
private void button5_Click(object sender, EventArgs e)
{
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
}
private void button6_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlCommandBuilder cb;
cb = new System.Data.SqlClient.SqlCommandBuilder(da);
DataRow dRow = ds1.Tables["Workers"].NewRow();
dRow[1] = textBox1.Text;
dRow[2] = textBox2.Text;
dRow[3] = textBox3.Text;
ds1.Tables["Workers"].Rows.Add(dRow);
MaxRows = MaxRows + 1;
inc = MaxRows - 1;
da.Update(ds1, "Workers"); //exception is raised on this line...
MessageBox.Show("entery added into database");
}
}
}
Reply
Answers (
2
)
Provider in ADO.NET
what is globalvariable in sql server