Comments by good.shankar (Top 7 by date)

sorry My Code

public partial class Students : Form
{
DBOprX dbOpr = new DBOprX();
BindingSource bs = new BindingSource(new System.ComponentModel.Container());
DataSet ds = new DataSet();

public Students()
{
InitializeComponent();
}

private void btnAdd_Click(object sender, EventArgs e)
{
if (Validate())
{
return;
}
dbOpr.ExecuteMSSQLQry("INSERT INTO Stu (Name, Address, Phone) VALUES ('" + txtName.Text + "', '" + txtAddress.Text + "', '" + txtPhone.Text + "')");

Reset();
GetData();
}

private void btnUpdate_Click(object sender, EventArgs e)
{
if (Validate())
{
return;
}
dbOpr.ExecuteMSSQLQry("UPDATE Stu SET Name = '" + txtName.Text + "', Address = '" + txtAddress.Text + "', Phone = '" + txtPhone.Text + "' WHERE Id = " + cboStudents.SelectedValue.ToString() + "");

Reset();
GetData();
}

private void btnDelete_Click(object sender, EventArgs e)
{
dbOpr.ExecuteMSSQLQry("DELETE FROM Stu WHERE Id = " + cboStudents.SelectedValue.ToString() + "");

Reset();
GetData();
}

private void btnReset_Click(object sender, EventArgs e)
{
Add();
Reset();
//RefreshData();
}

private void Students_Load(object sender, EventArgs e)
{
GetData();
Add();
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
Int32 q;
if (cboStudents.SelectedIndex == -1 || !Int32.TryParse(cboStudents.SelectedValue.ToString(),out q))
{
return;
}

ds = dbOpr.SelectMSSQLQry("SELECT * FROM Stu WHERE Id = '" + cboStudents.SelectedValue.ToString() + "'", "StuDetails");

if (ds.Tables["StuDetails"].Rows.Count == 0)
{
return;
}

txtName.Text = ds.Tables["StuDetails"].Rows[0]["Name"].ToString();
txtAddress.Text = ds.Tables["StuDetails"].Rows[0]["Address"].ToString();
txtPhone.Text = ds.Tables["StuDetails"].Rows[0]["Phone"].ToString();

Edit();
}

void Reset()
{
txtName.ResetText();
txtAddress.ResetText();
txtPhone.ResetText();
cboStudents.SelectedIndex = -1;
}

void Add()
{
btnAdd.Enabled = true;
btnUpdate.Enabled = false;
btnDelete.Enabled = false;
}

void Edit()
{
btnAdd.Enabled = false;
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
}

void GetData()
{
ds = dbOpr.SelectMSSQLQry("Select * FROM Stu", "Students");

bs.DataMember = "Students";
bs.DataSource = ds;

cboStudents.DataSource = bs;
cboStudents.DisplayMember = "Name";
cboStudents.ValueMember = "Id";

cboStudents.SelectedIndex = -1;
}

bool Validate()
{
if (String.IsNullOrEmpty(txtName.Text))
{
MessageBox.Show("Please Enter Name");
return true;
}
return false;
}

code in the link...

Oh... U all are taking it to a higher level....
I just want to load menu according to the user type. whats the solution for that...

I didnt find any property connection.connectionString for my dataset object...