Comments by martyres72 (Top 33 by date)

not all of my code copied in. Here is the section from gridview, containing the hyperlink I am trying to update:

<asp:TemplateField HeaderText="aaaa">
<itemtemplate>
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='~/bogus.aspx'>Contact

updated the question with markup and code.

I believe you are right, but I'm not sure where changes needed. code below to save to db.

protected void Button1_Click(object sender, EventArgs e)
{

Byte[] bytes = null;
if (FileUpload1.HasFile)
{
string filename = FileUpload1.PostedFile.FileName;
string filePath = Path.GetFileName(filename);
Stream fs = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
bytes = br.ReadBytes((Int32)fs.Length);
}

string insertCmd = "INSERT INTO Solids VALUES (@CustomerID,@WellID,@TestDate,@SampleDate,@LabID,@SampleLoc,@Appearance,@Weight,@WeightwSample,@PostXylene,@AceticWash,@WaterWash,@HclWash,@SampleWeight,@PercentHydro,@PercentIron,@PercentCarb,@PercentSalts,@PercentAcid,@Comments,@sulfides,@createdby,@createddate,@image)";
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["AMTConnectionString"].ConnectionString))
{
conn.Open();
SqlCommand myCommand = new SqlCommand(insertCmd, conn);
// Create parameters for the SqlCommand object
// initialize with input-form field values
myCommand.Parameters.AddWithValue("@CustomerID", TextBox2.Text);
myCommand.Parameters.AddWithValue("@WellID", TextBox3.Text);
myCommand.Parameters.AddWithValue("@TestDate", TestDate.Text);
myCommand.Parameters.AddWithValue("@SampleDate", SampleDate.Text);
myCommand.Parameters.AddWithValue("@LabID", TextBox16.Text);
myCommand.Parameters.AddWithValue("@SampleLoc", TextBox14.Text);
myCommand.Parameters.AddWithValue("@Appearance", TextBox5.Text);
myCommand.Parameters.AddWithValue("@Weight", TextBox6.Text);
myCommand.Parameters.AddWithValue("@WeightwSample", TextBox7.Text);
myCommand.Parameters.AddWithValue("@PostXylene", TextBox1.Text);
myCommand.Parameters.AddWithValue("@AceticWash", TextBox13.Text);
//myCommand.Parameters.AddWithValue("@WaterWash", TextBox8.Text);
if (!string.IsNullOrEmpty(TextBox8.Text))
{
myCommand.Parameters.AddWithValue("@WaterWash", TextBox8.Text);
}
else
{
myCommand.Parameters.AddWithValue("@WaterWash", 0);
}
myCommand.Parameters.AddWithValue("@HclWash", TextBox17.Text);
myCommand.Parameters.AddWithValue("@SampleWeight", TextBox17.Text);//computed value; any initial value will do; sql table trigger computes real value
myCommand.Parameters.AddWithValue("@PercentHydro", TextBox8.Text);//computed value; any initial value will do; sql table trigger computes real value
myCommand.Parameters.AddWithValue("@PercentIron", TextBox8.Text);//computed value; any initial value will do; sql table trigger computes real value
myCommand.Parameters.AddWithValue("@PercentCarb", TextBox8.Text);//computed value; any initial value will do; sql table trigger computes real value
myCommand.Parameters.AddWithValue("@PercentSalts", TextBox8.Text);//computed value; any initial value will do; sql table trigger computes real value
myCommand.Parameters.AddWithValue("@PercentAcid", TextBox8.Text);//computed value; any initial value will do; sql table trigger computes real value

myCommand.Parameters.AddWithValue("@Comments", TextBox15.Text);
myCommand.Parameters.AddWithValue("@Sulfides", DropDownList1.Text);
myCommand.P

code added.