Click here to Skip to main content
15,918,889 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
dear sir i want to insert the data in the tables in the database through the asp.net
but data is not inserted in the database...
i have written the following code:
C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class Registration : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection("Data Source=LAPTOP-0800NRBO\\SQL;Initial Catalog=HealthCaareAdvisor;User ID=sa;Password=nitinmca");
    SqlCommand cmd;
    DataSet ds,ds1,ds2,ds3 = new DataSet();
    SqlDataAdapter sda,sda1,sda2,sda3;
    public void show()
    {
        //ds = null;
        sda = new SqlDataAdapter("select Gender from Registration", con);
        sda.Fill(ds);
        DrdpGender.DataSource = ds;
        DrdpGender.DataTextField = ds.Tables[0].Columns[0].ToString();
        DrdpGender.DataValueField = ds.Tables[0].Columns[0].ToString();
       DrdpGender.DataBind();
       // ds1 = null;
        sda1 = new SqlDataAdapter("select city from Registration", con);
        sda1.Fill(ds1);
        DrdpCity.DataSource = ds1;
        DrdpCity.DataTextField = ds.Tables[0].Columns[1].ToString();
        DrdpCity.DataValueField = ds.Tables[0].Columns[1].ToString();
        DrdpCity.DataBind();
       // ds2 = null;
        sda2 = new SqlDataAdapter("select qualification from Registration", con);
        sda2.Fill(ds2);
        DrdpQualification.DataSource = ds2;
        DrdpQualification.DataTextField = ds.Tables[0].Columns[2].ToString();
        DrdpQualification.DataValueField = ds.Tables[0].Columns[2].ToString();
        DrdpQualification.DataBind();
       // ds3 = null;
        sda3 = new SqlDataAdapter("Select Occupation  from Registration", con);
        sda3.Fill(ds3);
        DrdpOccupation.DataSource = ds3;
        DrdpOccupation.DataTextField = ds.Tables[0].Columns[3].ToString();
        DrdpOccupation.DataValueField = ds.Tables[0].Columns[3].ToString();
        DrdpOccupation.DataBind();        
    }

    public void fillgrid()
    {
        con.Open();
        DataSet dsGridview = new DataSet();
        SqlDataAdapter sdaGridview = new SqlDataAdapter("select * from Registration", con);
        sdaGridview.Fill(dsGridview);
        GridView1.DataSource = dsGridview;
        GridView1.DataBind();
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            show();
            fillgrid();
        }
    }

    protected void BtnRegister_Click(object sender, EventArgs e)
    {
        try
        {
            con.Open();
            string str = "insert into Registration values(@RegID,@Name,@LName,@DOB,@gender,@EmailP,@EmailS,@ContactP,@ContactS,@Address,@City,@Qualification,@Occupation,@Password)";
            cmd.Parameters.AddWithValue("@RegID", TxtregID.Text);
            cmd.Parameters.AddWithValue("@Name", Txtname.Text);
            cmd.Parameters.AddWithValue("@LName", TxtLname.Text);
            cmd.Parameters.AddWithValue("@DOB", DrdpGender.SelectedItem.Text);
            cmd.Parameters.AddWithValue("@EmailP", txtEmailP.Text);
            cmd.Parameters.AddWithValue("@EmailS", TxtEmailS.Text);
            cmd.Parameters.AddWithValue("@ContactP", TxtContactP.Text);
            cmd.Parameters.AddWithValue("@ContactS", TxtContactS.Text);
            cmd.Parameters.AddWithValue("@Address", TxtAddr.Text);
            cmd.Parameters.AddWithValue("@City", DrdpCity.SelectedItem.Text);
            cmd.Parameters.AddWithValue("@Qualification", DrdpQualification.SelectedItem.Text);
            cmd.Parameters.AddWithValue("@Occupation", DrdpOccupation.SelectedItem.Text);
            cmd.Parameters.AddWithValue("@Password", txtpass);

            cmd.ExecuteNonQuery();
            show();
            fillgrid();
            Response.Write("Record inserted");
        }

        catch (SqlException ex)
        {
            Response.Write("sorry Exception occured" + ex.Message);
        }
        finally
        {
            con.Close();
        }
    }
}

but it is showing the follwoing exception error...
Value cannot be null.
Parameter name: dataSet

here the code snippet that is generating exception:
 //ds = null;
Line 19:         sda = new SqlDataAdapter("select Gender from Registration", con);
Line 20:         sda.Fill(ds);
Line 21:         DrdpGender.DataSource = ds;
Line 22:         DrdpGender.DataTextField = ds.Tables[0].Columns[0].ToString();


What I have tried:

i have tried the dropdown list databinding but not result
Posted
Updated 25-Apr-16 20:32pm
v2
Comments
Beginers*Devloper 26-Apr-16 1:53am    
command.Parameters.Add("@columnnm ", SqlDbType.VarChar).Value = txtcolumn.text;
u use this type of syntax...
And ur Dropdown is bind or not??

1 solution

Change it to below format for all the dropdownlists

C#
sda = new SqlDataAdapter("select Gender from Registration", con);
sda.Fill(ds);
DrdpGender.DataSource = ds;
DrdpGender.DataTextField = "Gender"
DrdpGender.DataValueField = "Gender"
DrdpGender.DataBind();


dont use
C#
 ds.Tables[0].Columns[1].ToString();
          ds.Tables[0].Columns[2].ToString();
          ds.Tables[0].Columns[3].ToString();  


Initiate the sql command

C#
string str = "insert into Registration values(@RegID,@Name,@LName,@DOB,@gender,@EmailP,@EmailS,@ContactP,@ContactS,@Address,@City,@Qualification,@Occupation,@Password)";
           cmd = new SqlCommand(str, con);
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900