Comments by AshishvermaMCA

AshishvermaMCA 12-May-15 8:00am View

Thanks Maciej Los
For giving solution.

AshishvermaMCA 12-May-15 3:44am View

Hi Maciej Los,
I will face one more problem when i an using OleDbCommand cmd = new OleDbCommand("SELECT ColumnName1, ColumnName2, ColumnNameX FROM [" + dt.ToString() + "]", oledbConn);

because if user change the column name in Excel file then how i will handle this.

AshishvermaMCA 12-May-15 3:42am View

No I can't replace - SELECT * FROM [" + dt.ToString() + "] with SELECT ColumnName1, ColumnName2, ColumnNameX FROM [" + dt.ToString() + "]

Actually my objective is When i am going to upload Excel file need to check excel columns is exact with my column which is used in code like
ds.Tables[0].Rows[i]["ColumnName1"].ToString();

AshishvermaMCA 12-May-15 3:18am View

I am using this code to take data from excel file-

oledbConn.Open();
object dt = oledbConn.GetSchema("Tables").Rows[0]["TABLE_NAME"];

OleDbCommand cmd = new OleDbCommand("SELECT * FROM [" + dt.ToString() + "]", oledbConn);
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
oleda.Fill(ds, "WellCareMCD");
oledbConn.Close();

AshishvermaMCA 3-Nov-14 6:44am View

All records which are displayed into Grid View.
Suppose 20 records is displayed . I need to save 20 records into database sql server on a click of button without implementing loop functionality.

AshishvermaMCA 20-Oct-14 7:40am View

Thanks to all of you!!

AshishvermaMCA 20-Oct-14 7:40am View

Thanks

AshishvermaMCA 18-Sep-14 3:02am View

hi,
Actually, i am not familiar with any Design pattern and want to implement it into my project for learning purpose.

AshishvermaMCA 14-Mar-14 5:53am View

This article is not clear my doubt.

AshishvermaMCA 28-Jan-14 0:30am View

Thanks Gitanjali Singh...
I have done this...

AshishvermaMCA 18-Apr-13 5:12am View

i have chaged according to you but still issue remains same. data.d[i].FName having the records i saw the value by debuging it. When assign these values to textbox but values is not displaying in textbox. $("#<%=txtFname.ClientID%>").val(data.d[i].FName);

AshishvermaMCA 18-Apr-13 4:52am View

thanks i m trying suggest by you.

AshishvermaMCA 9-Apr-13 6:03am View

imp question.

Comments by AshishvermaMCA (Top 13 by date)