ASP.NET

Michael101 wrote:

My problem is that I don't know how to get my VB.NET web system to talk to Command Prompt and pass it arguments that I'll use to talk to MQ.

pmarfleet wrote:

The error message tells you all you need to know.

 protected void btnAdd_Click(object sender, EventArgs e)<br />
    {<br />
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MYConnectionString"].ConnectionString);<br />
        SqlDataAdapter da = new SqlDataAdapter("SELECT subcat_id,subcatename,description,Pid  FROM Subcatagory", con);<br />
        DataTable dt = new DataTable();<br />
        da.Fill(dt);<br />
<br />
        // Here we'll add a blank row to the returned DataTable<br />
        DataRow dr = dt.NewRow();<br />
        dt.Rows.InsertAt(dr, 0);<br />
        //Creating the first row of GridView to be Editable<br />
        GridView1.EditIndex = 0;<br />
        GridView1.DataSource = dt;<br />
        GridView1.DataBind();<br />
        <br />
        //Changing the Text for Inserting a New Record<br />
<br />
        //dt.Reset();<br />
         //here the lick button shown "insert"<br />
        ((LinkButton)GridView1.Rows[0].Cells[5].Controls[0]).Text = "Insert";<br />
        Session["operation"] = "Insert"; <br />
<br />
    }<br />
<br />
When control leaves the scope it automatic use "Update"<br />

<br />
<br />
  protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)<br />
    {<br />
<br />
           <big>// The following link button every time shown me update value</big><br />
<br />
        if (((LinkButton)GridView1.Rows[0].Cells[5].Controls[0]).Text == "Insert" || Session["operation"] == "Insert")<br />
        {<br />
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MYConnectionString"].ConnectionString);<br />
            SqlCommand cmd = new SqlCommand();<br />
            cmd.CommandText = "INSERT INTO Subcatagory(subcatename,description,Pid) VALUES(@subcatename,@description,@Pid)";<br />
            //cmd.CommandText = "INSERT INTO Subcatagory(subcatename,description,Pid) VALUES('llll','kkkkk',1)";<br />
            cmd.Parameters.Add("@subcatename", SqlDbType.VarChar).Value = ((TextBox)GridView1.Rows[0].Cells[2].Controls[0]).Text;<br />
            cmd.Parameters.Add("@description", SqlDbType.VarChar).Value = ((TextBox)GridView1.Rows[0].Cells[4].Controls[0]).Text;<br />
            cmd.Parameters.Add("@Pid", SqlDbType.Int).Value = Int32.Parse(Request.QueryString["Pid"]);        <br />
            cmd.Connection = con;<br />
            con.Open();<br />
            cmd.ExecuteNonQuery();<br />
            con.Close();<br />
<br />
        }<br />
        else<br />
        {<br />
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MYConnectionString"].ConnectionString);<br />
            SqlCommand cmd = new SqlCommand();<br />
            cmd.CommandText = "UPDATE Subcatagory SET subcatename=@subcatename,description=@description WHERE subcat_id=@subcat_id";<br />
            cmd.Parameters.Add("@subcatename", SqlDbType.VarChar).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text;<br />
            cmd.Parameters.Add("@description", SqlDbType.VarChar).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text;<br />
            cmd.Parameters.Add("@subcat_id", SqlDbType.Int).Value = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text);<br />
            cmd.Connection = con;<br />
            con.Open();<br />
            cmd.ExecuteNonQuery();<br />
            con.Close();<br />
}<br />
<br />
<br />
        GridView1.EditIndex = -1;<br />
        BindData();<br />
    }<br />
<br />
<br />
<br />