Insert a value into an sql statement

Your code is attempting to set DataRow object to "int" value (last line). Did you mean something like this:
 DataRow Comp = CompSet.Tables[0].Rows[0];
Could you be more specific into which sql statement  do you want to insert your value(int) ? How this sql statement is stored: as string ?

here is the sql statement

    public static DataSet CompDetailBindData(int PCID)
    {
        string connectionString = ConfigurationSettings.AppSettings["ConnectionString"];
        System.Data.SqlClient.SqlConnection sqlconnection = new System.Data.SqlClient.SqlConnection(connectionString);

        string queryString = "SELECT * FROM computer WHERE PC_ID = @PCID";
        System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand(queryString, sqlconnection);

        System.Data.SqlClient.SqlDataAdapter ad = new System.Data.SqlClient.SqlDataAdapter(sqlcommand);
        sqlcommand.Parameters.Add("@PCID", System.Data.SqlDbType.Int).Value = PCID;
       
        DataSet ds = new DataSet();
        ad.Fill(ds);
        return ds;
    }


Stelly

more info...
I want to be able to do this...
    protected void Page_Load(object sender, EventArgs e)
    {
        int PCID = Profile.PCID;

        DataSet CompSet = SQLQueries.CompDetailBindData(PCID);
        DataRow Comp = CompSet.Tables[0].Rows[0];

        LabelCompModel.Text = Comp("PcModel");
        TextBoxCCCSR.Text = Comp("CCSR");
        TextBoxEPSR.Text = Comp("EPSR");
        TextBoxShipDate.Text = Comp("ShipDate");

    }
}

Change round brackets to square ones and add ".ToString()" in

LabelCompModel.Text = Comp("PcModel");
        TextBoxCCCSR.Text = Comp("CCSR");
        TextBoxEPSR.Text = Comp("EPSR");
        TextBoxShipDate.Text = Comp("ShipDate");
to
LabelCompModel.Text = Comp["PcModel"].ToString();
        TextBoxCCCSR.Text = Comp["CCSR"].ToString();
        TextBoxEPSR.Text = Comp["EPSR"].ToString();
        TextBoxShipDate.Text = Comp["ShipDate"].ToString();

Getting a problem with the following line now its saying... "There is no row at position 0"
DataRow Comp = CompSet.Tables[0].Rows[0];

Stelly

it means that your table CompSet.Tables contains 0 rows. Add:
 if ( CompSet.Tables.Rows.Count > 0 )
{
   .. do something
}

where??

Stelly

I get  System.Data.DataTableCollection does not contain a definition for Rows

Stelly

Ok its now popping up but without any data in the fields... could it be this code??

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        CompList.DataSource = SQLQueries.CompListBindData();
        CompList.DataBind();
    }

    protected void CompList_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Button info = e.Row.FindControl("Info") as Button;
            info.Attributes.Add("onclick", "window.showModalDialog('CompDetails.aspx');");

        }
    }


    public void CompList_RowCommand(Object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "info")
        {
           
            int PCNo = Convert.ToInt32(e.CommandArgument);

            PCNo = Profile.PCID;
        }
    }

thanks,

Stelly

anyone?

Stelly

Are you sure that your SQL query returns data ?

Yes... I have tried it using a standard valus of 1 and it returns a value...

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        CompList.DataSource = SQLQueries.CompListBindData();
        CompList.DataBind();
    }

    protected void CompList_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Button info = e.Row.FindControl("Info") as Button;
            info.Attributes.Add("onclick", "window.showModalDialog('CompDetails.aspx');");

        }
    }


    public void CompList_RowCommand(Object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "info")
        {
           
            int PCNo = Convert.ToInt32(e.CommandArgument);

            PCNo = Profile.PCID;
        }
    }
Do you think its something to do with the profile??

Stelly

Run your (EXACTLY the same as your application uses) query directly in SQL QueryAnalyzer with parameter (proile ID) which return no output. If you get back no result, then your application is OK and there is just no data in databse for this profile ID

I have run the SQL query and it works fine it just trying to pass it a value now... i will open a new question for that

Stelly