how to retrive the database values

Question

how to retrive the database values plz send c# code and storage procedure

Jignesh Trivedi · Answer

hi please refer below link it might help you. http://dbtutorials.com/advanced/using-stored-procedures-cs.aspx http://www.akadia.com/services/dotnet_data_reader.html http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-from-data-into-database-using-stored-procedure-in/

Mr Indian · Answer

Perhaps something like this... using System.Data.OleDb; using System.Data; namepsace whatever { public partial class MainForm : Form { public MainForm() { InitializeComponent(); this.WindowState = FormWindowState.Maximized; myCon = new OleDbConnection(@Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\...databasename.mdb); } OleDbConnection myCon; OleDbCommand cmd; OleDbDataAdapter adapter; DataSet ds; private void btnGetData_Click(object sender EventArgs e) { adapter = new OleDbDataAdapter(select * from SomeTableName myCon); ds = new DataSet(); adapter.Fill(ds TableName); adapter.Update(ds TableName); txtID.Text = ds.Tables[0].Rows[rno][0].ToString(); CBTitle.Text = ds.Tables[0].Rows[rno][2].ToString(); } }

Satyapriya Nayak · Answer

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; using System.Data.OleDb; namespace Insert_Update_Delete_DataGridView { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { bindgrid(); } private void bindgrid() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from employee; com = new OleDbCommand(str con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds employee); dataGridView1.DataMember=employee; dataGridView1.DataSource = ds; con.Close(); } }