7
Answers

Object reference not set to an instance of an object.

Okay,First of all let me introduce myself as newbee to this language.
this is my third day with program,I usually Practice at college where Visual studio 2010 is installed.
I have VS2012 ultimate.
If I sound silly forgive me,but I am really desperate here.

1st Problem,I couldnt create New SQL server database,so I added a newone with name database.mdf.
2nd I ceated a table and so on...now lets come to the code I have written.

Also I forgot to mention that same code works great with VS 2010 at my college PC.
Now I am confused.

error "Object reference not set to an instance of an object." at Form1_Load..I have mention in code too.

  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using System.Configuration;
  11. using System.Data.SqlClient;
  13. namespace WindowsFormsApplication1
  14. {
  15. public partial class Form1 : Form
  16. {
  17. SqlConnection con;
  18. SqlCommand cmd;
  19. SqlDataAdapter sda;
  20. SqlDataReader sdr;
  21. DataSet ds;
  23. public Form1()
  24. {
  25. InitializeComponent();
  26. }
  28. private void Form1_Load(object sender, EventArgs e)
  29. {
  30. string st = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;//Object reference not set to an instance of an object.
  31. con = new SqlConnection(st);
  32. fill();
  34. }
  36. public void fill()
  37. {
  38. if (con.State != ConnectionState.Open)
  39. {
  40. con.Open();
  41. }
  43. string qry = "Select *from Table";
  44. cmd = new SqlCommand(qry, con);
  45. sda = new SqlDataAdapter(cmd);
  46. ds = new DataSet();
  47. sda.Fill(ds);
  48. ds.Tables[0].TableName = "abc";
  49. dataGridView1.DataSource = ds.Tables["abc"];
  50. }
  52. private void btn_Save_Click(object sender, EventArgs e)
  53. {
  54. string qry = "INSERT INTO Table(Name,Roll,Grade)Values('" + textBox1.Text + "', '" + textBox2.Text + "', '" + textBox3.Text + "')";
  55. cmd = new SqlCommand(qry, con);
  56. cmd.ExecuteNonQuery();
  57. fill();
  58. textBox1.Text = "";
  59. textBox2.Text = "";
  60. textBox3.Text = "";
  61. }
  63. private void btn_Delete_Click(object sender, EventArgs e)
  64. {
  66. string qry = "DELETE FROM Table WHERE Name='" + textBox1.Text + "'";
  67. cmd = new SqlCommand(qry, con);
  68. cmd.ExecuteNonQuery();
  69. fill();
  70. MessageBox.Show("File Deleted");
  71. textBox1.Text = "";
  72. textBox2.Text = "";
  73. textBox3.Text = "";
  74. }
  76. private void btn_update_Click(object sender, EventArgs e)
  77. {
  79. string qry = "Update Table set Name = '" + textBox1.Text + "',Grade = '" + textBox3.Text + "' where Roll = '" + textBox2.Text + "'";
  80. cmd = new SqlCommand(qry, con);
  81. cmd.ExecuteNonQuery();
  82. fill();
  83. textBox1.Text = "";
  84. textBox2.Text = "";
  85. textBox3.Text = "";
  86. }
  88. private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
  89. {
  91. }
  92. }
  93. }

one more thing ,I couldnt create dbo file(as I couldnt create New SQL database),so I created a new .mdf via add new connection.
Does this affect the coding?

Answers (7)