<br />
protected void lnkSave_Clock(object sender,EventArgs e)<br />
{<br />
DataSet ds = GetExcel("c:\\Details.xls");<br />
foeach(DataRow row in ds.Tables[0])<br />
{<br />
insertRowToDB(row["coulmnName1"],row["coulmnName1"],row["coulmnName1"],row["coulmnName1"]);
}<br />
}<br />
<br />
Private Void InsertRowToDb(object co1,object co2,object co3 ,object co4)
{<br />
SqlParameterCollection myPar = new SqlCommand().Parameters;<br />
myPar.Add("@id", id);<br />
myPar.Add("@type", type);<br />
myPar.Add("@participantType", participantType);<br />
myPar.Add("@participantID", participantID);<br />
myPar.Add("@permissionDate", permissionDate);<br />
myPar.Add("@startDate", startDate);<br />
myPar.Add("@endDate", endDate);<br />
myPar.Add("@cardType", cardType);<br />
myPar.Add("@fn", fn);<br />
return Abstract.executeNonQuery("p_InsertNewInterancePermission", myPar);<br />
}<br />
<br />
<br />
public bool executeNonQuery(string command, SqlParameterCollection parameters)<br />
{<br />
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("ar-sa");<br />
SqlConnection con = new SqlConnection("your connection string ");<br />
SqlCommand com = new SqlCommand(command, con);<br />
com.CommandType = CommandType.StoredProcedure;<br />
<br />
for (int t = 0; t < parameters.Count; t++)<br />
{<br />
SqlParameter myParam = parameters[t];<br />
parameters[t] = new SqlParameter();<br />
com.Parameters.Add(myParam);<br />
}<br />
<br />
try<br />
{<br />
con.Open();<br />
int s = com.ExecuteNonQuery();<br />
con.Close();<br />
if (s > 0)<br />
{<br />
return true;<br />
}<br />
else<br />
{<br />
return false;<br />
}<br />
}<br />
catch (Exception)<br />
{<br />
con.Close();<br />
return false;<br />
}<br />
}<br />