how to save checked item into database. RSS

• • Reply
  

  apurva16

  Member

  21 Points

  87 Posts

  Re: how to save checked item into database.

  Apr 07, 2012 09:58 AM|LINK

  hi,

  i try with your suggestion.check the following code and tell me where i getting wrong.when i debug error getting.

  No mapping exists from object type System.Web.UI.WebControls.ListItem to a known managed provider native type.

  foreach (ListItem listItem in chkmenuRights.Items)
          {
              if (listItem.Selected == true)
              {
  
          SqlConnection con = new SqlConnection(strConnection);
          con.Open();
          cmd = new SqlCommand("Insert Into UserCreation(FullName,UserName,Email,PhoneNo,RegionID,StateId,CityID,Password,SecurityQue,SecurityAns,MenuMasterID) VALUES(@FullName,@UserName,@Email,@PhoneNo,@RegionID,@StateId,@CityID,@Password,@SecurityQue,@SecurityAns,@MenuMasterID)", con);
          cmd.CommandType = CommandType.Text;
          cmd.Parameters.AddWithValue("@FullName", txtFullname.Text);
          cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);
          cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
          cmd.Parameters.AddWithValue("@PhoneNo", txtPhoneno.Text);
          cmd.Parameters.AddWithValue("@RegionID", DdlRegion.SelectedValue);
          cmd.Parameters.AddWithValue("@StateId", DdlState.SelectedValue);
          cmd.Parameters.AddWithValue("@CityID", DdlCity.SelectedValue);
          cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
          cmd.Parameters.AddWithValue("@SecurityQue", txtSecurityquestion.Text);
          cmd.Parameters.AddWithValue("@SecurityAns", txtSecurityanswer.Text);
          cmd.Parameters.AddWithValue("@MenuMasterID",chkmenuRights.SelectedItem);
          cmd.ExecuteNonQuery();
          con.Close();
          
              }

  
  
  

• • Reply
  

  sanjayverma_...

  Participant

  1568 Points

  361 Posts

  Re: how to save checked item into database.

  Apr 07, 2012 10:00 AM|LINK

  Hi,

  For doing this you need to create a string fo all the checkbox checked item with coma sepration it may be like this

  //Loop YTo find Control within ContentplaceHolder
          ContentPlaceHolder cph = (ContentPlaceHolder)Master.FindControl("ContentPlaceHolder1");
  
          for (int i = 1; i < 38; i++)
          {
  
              TextBox textBox = (TextBox)cph.FindControl("TextBox" + i.ToString());
  
              if (textBox.Text != "")
              {
                  objsubpred.Result1 = objsubpred.Result1 + "," + textBox.Text;
              }
  
          }

  and then in the database you can use delemate and saprate the string with coma

  it will be somthing like this

  BEGIN
              DECLARE @NextString NVARCHAR(MAX),@Pos INT,@String NVARCHAR(MAX),@Delimiter NVARCHAR(MAX),@res AS BIT    
              
              SET @Delimiter    = ','
              SET @String            = @SubPredictionNameString + @Delimiter
              SET @Pos            = charindex(@Delimiter,@String)
              IF NOT EXISTS(SELECT * FROM AllSportsSpecialSubPrediction WHERE SportsId=@SportsId AND CSId=@CSId AND LeagueId=@LeagueId AND PredictionId=@PredictionId AND IsActive='True')
              BEGIN            
              WHILE (@pos <> 0)
                  BEGIN
                  SET @NextString = substring(@String,1,@Pos - 1)
                      INSERT INTO AllSportsSpecialSubPrediction(SportsId,CSId,LeagueId,PredictionId,SpecialSubPredictionName,CreatedDate,CreatedBy) VALUES (@SportsId,@CSId,@LeagueId,@PredictionId,@NextString,GETDATE(),@UserId)
                      --NEXT Prediction
                      SET @String = substring(@String,@pos+1,len(@String))
                      SET @pos    = charindex(@Delimiter,@String)
                      
                  END
                   SET @res= 1
              END
              ELSE
                      BEGIN
                          SET @res= 0
                      END        
                  SELECT @res        
              
      END

  Be the Best.........
• • Reply
  

  apurva16

  Member

  21 Points

  87 Posts

  Re: how to save checked item into database.

  Apr 07, 2012 10:06 AM|LINK

  not getting..tell me incase of my code..posted above..

• • Reply
  

  apurva16

  Member

  21 Points

  87 Posts

  Re: how to save checked item into database.

  Apr 08, 2012 02:21 PM|LINK

  anyone pls help me...

• • Reply
  

  sanjayverma_...

  Participant

  1568 Points

  361 Posts

  Re: how to save checked item into database.

  Apr 09, 2012 02:03 PM|LINK

  Hi ,Apurva

  your code will be like this

  string s="";
  
  foreach (ListItem listItem in chkmenuRights.Items)
          {
              if (listItem.Selected == true)
              {
            
                 s= s +","+ chkmenuRights.SelectedItem;
      }
       }
  
  
     s=s.Substring(1);
  
  
      cmd.CommandType = CommandType.Text;
          cmd.Parameters.AddWithValue("@FullName", txtFullname.Text);
          cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);
          cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
          cmd.Parameters.AddWithValue("@PhoneNo", txtPhoneno.Text);
          cmd.Parameters.AddWithValue("@RegionID", DdlRegion.SelectedValue);
          cmd.Parameters.AddWithValue("@StateId", DdlState.SelectedValue);
          cmd.Parameters.AddWithValue("@CityID", DdlCity.SelectedValue);
          cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
          cmd.Parameters.AddWithValue("@SecurityQue", txtSecurityquestion.Text);
          cmd.Parameters.AddWithValue("@SecurityAns", txtSecurityanswer.Text);
          //Pass the string hear Like this
           cmd.Parameters.AddWithValue("@MenuMasterID",s);
  
    //Then In sql do it like this
  
  CREATE PROCEDURE [dbo].[InsertSportsName]
  
  ALTER PROCEDURE [dbo].[InsertSportsName]
  
  @FullName   NVARCHAR(MAX),
  @UserName   NVARCHAR(MAX),
  -
  -
  -
  
  @MenuMasterID    NVARCHAR(MAX)
  
  
  AS
   BEGIN
              DECLARE @NextString NVARCHAR(MAX),@Pos INT,@String NVARCHAR(MAX),@Delimiter NVARCHAR(MAX),@res AS BIT    
              
              SET @Delimiter    = ','
              SET @String            = @MenuMasterID    + @Delimiter
              SET @Pos            = charindex(@Delimiter,@String)
                   
              WHILE (@pos <> 0)
                  BEGIN
                  SET @NextString = substring(@String,1,@Pos - 1)
                      INSERT INTO AllSportsSpecialSubPrediction(SportsId,CSId,LeagueId,PredictionId,SpecialSubPredictionName,CreatedDate,CreatedBy) VALUES
  
  (@SportsId,@CSId,@LeagueId,@PredictionId,@NextString,GETDATE(),@UserId)
                      --NEXT Prediction
                      SET @String = substring(@String,@pos+1,len(@String))
                      SET @pos    = charindex(@Delimiter,@String)
                      
                  END
                   SET @res= 1
              END
              ELSE
                      BEGIN
                          SET @res= 0
                      END        
                  SELECT @res        
              
      END
  LEt me know if any issue

  Be the Best.........
• • Reply
  

  apurva16

  Member

  21 Points

  87 Posts

  Re: how to save checked item into database.

  Apr 09, 2012 02:59 PM|LINK

  i done with your suggestion but giving following error.

  Conversion failed when converting the nvarchar value 'Login,Login,Login' to data type int.

  protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
      {
          string s="";
  
          foreach (ListItem listItem in chkmenuRights.Items)
          {
              if (listItem.Selected == true)
              {
            
                 s= s +","+ chkmenuRights.SelectedItem;
               }
           }
  
  
            s=s.Substring(1);
  
          SqlConnection con = new SqlConnection(strConnection);
          con.Open();
          cmd = new SqlCommand("Insert Into UserCreation(FullName,UserName,Email,PhoneNo,RegionID,StateId,CityID,Password,MenuMasterID) VALUES(@FullName,@UserName,@Email,@PhoneNo,@RegionID,@StateId,@CityID,@Password,@MenuMasterID)", con);
          cmd.CommandType = CommandType.Text;
          cmd.Parameters.AddWithValue("@FullName", txtFullname.Text);
          cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);
          cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
          cmd.Parameters.AddWithValue("@PhoneNo", txtPhoneno.Text);
          cmd.Parameters.AddWithValue("@RegionID", DdlRegion.SelectedValue);
          cmd.Parameters.AddWithValue("@StateId", DdlState.SelectedValue);
          cmd.Parameters.AddWithValue("@CityID", DdlCity.SelectedValue);
          cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
         
          cmd.Parameters.AddWithValue("@MenuMasterID",s);
          cmd.ExecuteNonQuery();
          con.Close();
         
          ClientScript.RegisterStartupScript(this.GetType(), "Hello", "alert('Successfully created a user');", true);
          txtFullname.Text = "";
          txtUserName.Text = "";
          txtEmail.Text = "";
          txtPhoneno.Text = "";
          txtPassword.Text = "";
          txtConfirmpassword.Text = "";
          txtSecurityquestion.Text = "";
          txtSecurityanswer.Text = "";
          DdlRegion.SelectedIndex = 0;
          DdlState.SelectedIndex = 0;
          DdlCity.SelectedIndex = 0;
  
      }

  tell me where i am going wrong..

• • Reply
  

  sanjayverma_...

  Participant

  1568 Points

  361 Posts

  Re: how to save checked item into database.

  Apr 10, 2012 02:10 PM|LINK

  Hi apurva16

  i think you had taken

  @MenuMasterID as int take it as nvarchar.as we take the string with the coma septation.

  Be the Best.........
• • Reply
  

  mudassarkhan

  All-Star

  78956 Points

  13402 Posts

  MVP

  Re: how to save checked item into database.

  Apr 10, 2012 02:20 PM|LINK

  Using checkboxlist, you can save checked items to database and also repopulate

  http://www.aspsnippets.com/Articles/Save-and-Repopulate-Users-selections-from-Database-using-ASP.Net-CheckBoxList.aspx

  MAK [MVP ASP.Net] ASP.Net Freelancer

  ---

  
  Contact me
  
  
• • Reply
  

  tdmca

  Contributor

  2396 Points

  661 Posts

  Re: how to save checked item into database.

  Apr 10, 2012 02:31 PM|LINK

  protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
      {
          string s="";
  
          foreach (ListItem listItem in chkmenuRights.Items)
          {
              if (listItem.Selected == true)
              {
            
            //     s= s +","+ chkmenuRights.SelectedItem;  // you dont need to concatenate insert in same   table
             SqlCommand cmdtemp=new SqlCommand("insert into menurght values()") //pass values here
               }
           }
  
  
            s=s.Substring(1);
  
          SqlConnection con = new SqlConnection(strConnection);
          con.Open();
          cmd = new SqlCommand("Insert Into UserCreation(FullName,UserName,Email,PhoneNo,RegionID,StateId,CityID,Password,MenuMasterID) VALUES(@FullName,@UserName,@Email,@PhoneNo,@RegionID,@StateId,@CityID,@Password,@MenuMasterID)", con);
          cmd.CommandType = CommandType.Text;
          cmd.Parameters.AddWithValue("@FullName", txtFullname.Text);
          cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);
          cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
          cmd.Parameters.AddWithValue("@PhoneNo", txtPhoneno.Text);
          cmd.Parameters.AddWithValue("@RegionID", DdlRegion.SelectedValue);
          cmd.Parameters.AddWithValue("@StateId", DdlState.SelectedValue);
          cmd.Parameters.AddWithValue("@CityID", DdlCity.SelectedValue);
          cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
         
          cmd.Parameters.AddWithValue("@MenuMasterID", id);  // insert here id
          cmd.ExecuteNonQuery();
          con.Close();
         
          ClientScript.RegisterStartupScript(this.GetType(), "Hello", "alert('Successfully created a user');", true);
          txtFullname.Text = "";
          txtUserName.Text = "";
          txtEmail.Text = "";
          txtPhoneno.Text = "";
          txtPassword.Text = "";
          txtConfirmpassword.Text = "";
          txtSecurityquestion.Text = "";
          txtSecurityanswer.Text = "";
          DdlRegion.SelectedIndex = 0;
          DdlState.SelectedIndex = 0;
          DdlCity.SelectedIndex = 0;
  
      }

  If you feel helped. Please mark this post as Answer
• • Reply
  

  apurva16

  Member

  21 Points

  87 Posts

  Re: how to save checked item into database.

  Apr 11, 2012 04:54 AM|LINK

  hi,

  Which id i pass here??

  thanx.