Comments by vatsaldesai (Top 27 by date)

you have re posted it. it shows your name.

i have store value of dt1.Rows[i]["SentenceText1"].ToString() in one variable name abc and how can use this variable name abc in store procedure as input parameter to insert that variable's value.

protected void GridView1_RowCommand1(object sender, GridViewCommandEventArgs e )
{
if (e.CommandName == "click")
{

int index = Convert.ToInt32(e.CommandArgument.ToString());

if(index<0)
{
return;
}

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++)
{
sql = sql + "INSERT INTO Sentences(SentenceText) SELECT '" + dt1.Rows[i]["SentenceText1"].ToString() + "' FROM Sentences WHERE NOT EXISTS(SELECT '" + dt1.Rows[i]["SentenceText1"].ToString() + "' FROM Sentences WHERE SentenceText='" + dt1.Rows[i]["SentenceText1"].ToString() + "')";
sql = sql + "";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
}

means....???