Hi i am new at asp.net and sql server 2008. i have to write store procedure before that i explain you about database.
Content(contentid ident,contenttext varchar(500))
sentence(sentenceid ident,sentencetext varchar(500))
contentsentence(contentid,sentenceid,order no all are int)
and both content and sentence table has relation of pk and fk with contentsentence table.
i have write code that split content into sentence and data enter into sentence table.so i have to write store procedure that get current generated sentence id which can find using @@identity from sentence table and get contentid from which sentence is generated and also enter orderno which is manual inserted and stored in one variable.so when this store procedure fires its take value of currently generated sentenceid its related content id and manual entered orderno. this feilds inserted in contentsentence table.
i don't know how to write store procedure for this so please help me!!!
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();
}
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.
Submit an article or tip