how to use variable as parameter in store procedure

Question

0.00/5 (No votes)

See more:

hiii all, i have write this code.

C#

GridViewRow row = GridView1.Rows[index];

              var text = GridView1.Rows[index].Cells[0].Text;

              string tb = ((TextBox)GridView1.Rows[index].FindControl("txt1")).Text;

              String[] sentences = Regex.Split(text, @"(?<=[.!?])\s+(?=\p{Lt})");

              System.Data.DataTable dt1 = new System.Data.DataTable();

              dt1.Columns.Add("SentenceText1");

              foreach (string value in sentences)
              {
                  if(!string.IsNullOrWhiteSpace(value))
                  dt1.Rows.Add(value);
              }
              SqlConnection con = new SqlConnection(conn);
              con.Open();
              string sql = "";
              for (int i = 0; i < dt1.Rows.Count; i++)
              {
                    var abc = dt1.Rows[i]["SentenceText1"].ToString();

--------------------- call storeprocedure ------------------------------------
now i want to use abc in store procedure to insert this data into table "sentence " so how can i write store procedure with input parameter abc.

Posted 4-Mar-15 20:36pm

vatsaldesai

Updated 4-Mar-15 21:13pm

RajeeshMenoth

v2

Add a Solution

1 solution

Add a Solution

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

OriginalGriff · Accepted Answer · 2015-03-04T20:44:00

Try:

SQL

CREATE PROC [dbo].Sample
@UserName varchar(100)
AS
BEGIN
SELECT Id FROM myTable WHERE UserName = @UserName
END

Then call it:

C#

int id = -1;
using (SqlCommand com = new SqlCommand("Sample", con))
    {
    com.CommandType = CommandType.StoredProcedure;
    com.Parameters.AddWithValue("@UserName", abc);
    using (SqlDataReader read = com.ExecuteReader())
       {
       if (read.Read()) id = (int) read["Id"];
       }
    }

how to use variable as parameter in store procedure

1 solution

Solution 1

Add your solution here

Preview 0

how to use variable as parameter in store procedure

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us