Comments by Karthik Achari (Top 46 by date)

i am importing data from text file and updated in the grid view and database but i want to know how many new records are imported(irrespective of old records)
Thanks

I want to eliminate data row wise

Can you give me suggestion,

How can i insert data from text file to database table with out using gridview

Can you give me suggestion,

How can i insert data from text file to database table with out using gridview

yes i want all the cell of gridview act like buttons

okThanks a lot for spending your valuable time.

Thanks for spending time to solve this problem.

I am not yet tested the code,after testing the code i can reply.

Iam sending sample data please go through it and help me.


Gridview:
01 A aa
02 B bb
03 C ee





After importing from excel,I want to create text document
If record is exists
Status= Already exists
Else
Saved Successfully.
Textdocument:

Column1 Column2 Status
01 A Already exists
02 B Already exists
03 C Already exists
04 D Saved successfully

can you help me,i want to write data from gridview.

Thanks.

i want in windowsform application,can you help me to solve this problem.

I am trying to insert data rowwise i.e.,for row1 insert all column elements, lly for row2

can you help me how to insert data from grid view after importing.

I used Insert statement to insert data from gridview but it is showing invalid column names.

after importing the data from excel sheet is updated in gridview, but when i open database table it is not updated.

Thanks for your support.

i am using .Netframework 2.0

private void button2_Click(object sender, EventArgs e)
{

OleDbConnection cnCSV = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + textBox1.Text + "; Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\";");
//OleDbConnection cnCSV = new OleDbConnection(strConnectionString);
OleDbDataAdapter das = new OleDbDataAdapter("Select *from [Sheet1$]", cnCSV);
DataSet da = new DataSet();

das.Fill(da);
dataGridView1.DataSource = da;

}

This is the code what i have used for my application.

OleDbConnection cnCSV = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + textBox1.Text + "; Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\";");

when i use this connection string and click on import button.It clears the data from grid view.

Can you help me to solve this issue.

Again same error was occured

it won't work.

Thanks for your support

After writing this line dataGridview.DataBind();


it shows error The name 'dataGridview' does not exist in the current context.

I am using .NET framework 2.0 & WindowsFormsApplication.

grid is there but it shows error 'dataGridview' does not exist in the current context

I am new to C# can you suggest me necessary changes.
Thanks

Thanks a lot

NO

Thanks

I am a fresher could you please suggest some Reference books because I don't have any idea about SQL now iam learning

Thanks

I tried with that also but it is not working
Insted of changing Status each and every time by specifying particular Emp_id I am trying to update Dynamically

Can you tell me where to set @PDate because I am a begineer to SQL
Eg: @PDate between '02-1-13' AND '02-28-13'

Thanks

datatype for In_Punch & Out_Punch was datetime
datatype for status was varchar(MAX)

I used datetime datatype for In_Punch & out_Punch,Convereted to VARCHAR datatype

Thanks

Thanks

Consider for my database only

Thanks Soumitra Mithu

Thanks Jain Nishant

Thanks CHill60

Thanks vaibhavimokal

Iam using MS SQLserver2008R2

How to create stored procedure in sql can any one help me because iam a fresher(begineer)