need to save the viewstate data in a gridview and outside da

Question

need to save the data outside the viewstate

i have a gridview and outside the gridview i have the textbox and dropdown box .in viewstate i can save the gridview data but i need the data in textbox and dropdown data to save my code is

private void InsertRecords(StringCollection sc)

{

SqlConnection conn = new SqlConnection(GetConnectionString());

StringBuilder sb = new StringBuilder(string.Empty);

string[] splitItems = null;

foreach (string item in sc)

{

const string sqlStatement = "INSERT INTO salz (sectionname,productname,lotno) VALUES";

if (item.Contains(","))

{

splitItems = item.Split(",".ToCharArray());

sb.AppendFormat("{0}('{1}','{2}','{3}'); ", sqlStatement, splitItems[0], splitItems[1], splitItems[2]);

}

}

try

{

conn.Open();

SqlCommand cmd = new SqlCommand(sb.ToString(), conn);

cmd.CommandType = CommandType.Text;

cmd.ExecuteNonQuery();

//Display a popup which indicates that the record was successfully inserted

Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Records Successfuly Saved!');", true);

}

catch (System.Data.SqlClient.SqlException ex)

{

string msg = "Insert Error:";

msg += ex.Message;

throw new Exception(msg);

}

finally

{

conn.Close();

}

}

http://s1279.photobucket.com/user/celvs/media/viewstatedata_zpspocvna3j.png.html?o=0