Click here to Skip to main content
15,911,786 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Mail box unavailable Pin
Sebastian T Xavier15-May-07 23:33
Sebastian T Xavier15-May-07 23:33 
AnswerRe: Mail box unavailable Pin
RichardGrimmer15-May-07 5:30
RichardGrimmer15-May-07 5:30 
GeneralRe: Mail box unavailable Pin
Sebastian T Xavier15-May-07 23:43
Sebastian T Xavier15-May-07 23:43 
GeneralRe: Mail box unavailable Pin
RichardGrimmer16-May-07 2:19
RichardGrimmer16-May-07 2:19 
Questionhow t ofind the control in itemtemplate of datalist Pin
sooreeagt14-May-07 21:19
sooreeagt14-May-07 21:19 
AnswerRe: how t ofind the control in itemtemplate of datalist Pin
DuckFace14-May-07 22:28
DuckFace14-May-07 22:28 
GeneralRe: how t ofind the control in itemtemplate of datalist Pin
sooreeagt14-May-07 22:54
sooreeagt14-May-07 22:54 
QuestionC#.net Problem Pin
vijay_8314-May-07 20:38
vijay_8314-May-07 20:38 
Hi,

I have a C#.net application in which i have read the datas from excel sheet and displayed in a datagrid in my Aspx form.

The code is here

private void Button2_Click(object sender, System.EventArgs e)
{

try
{
string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Salary.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
OleDbConnection conn = new OleDbConnection(strConnection);
//conn.Open();
OleDbCommand command = new OleDbCommand("SELECT * FROM [Sheet1$]", conn);
// command.Connection = conn;
// command.CommandType = CommandType.Text;
// command.CommandText = "SELECT * FROM [Sheet1]";
OleDbDataAdapter da = new OleDbDataAdapter(command);
DataSet ds = new DataSet();
//DataTable dt = new DataTable();
conn.Open();
da.Fill(ds, "EmpSal");
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
//da.Fill(dt);
conn.Close();
lblError.Text="The Excel sheet has been read";

//return dt;
}
catch (Exception ex)
{
Response.Write( ex.Message);
//return null;
}


}

the thing is that i have to upload the datas into the mysql database table. can anybody pls help me with the C#.net code. i need to use only mysql database.(coz we r using mysql db in our project)

Regards
Vijay.Smile | :)

AnswerRe: C#.net Problem Pin
Jaiprakash M Bankolli15-May-07 2:32
Jaiprakash M Bankolli15-May-07 2:32 
QuestionIssues in loading images in Word Automation [modified] Pin
Sankara Narayana14-May-07 20:13
Sankara Narayana14-May-07 20:13 
QuestionIs it possible ? Pin
Sandeep Akhare14-May-07 19:58
Sandeep Akhare14-May-07 19:58 
AnswerRe: Is it possible ? Pin
PSK_14-May-07 20:04
PSK_14-May-07 20:04 
GeneralRe: Is it possible ? Pin
Sandeep Akhare14-May-07 20:24
Sandeep Akhare14-May-07 20:24 
AnswerRe: Is it possible ? Pin
Jaiprakash M Bankolli15-May-07 2:34
Jaiprakash M Bankolli15-May-07 2:34 
AnswerRe: Is it possible ? Pin
RichardGrimmer15-May-07 5:31
RichardGrimmer15-May-07 5:31 
QuestionManage audio and video files Pin
Rahul Babu14-May-07 19:29
Rahul Babu14-May-07 19:29 
AnswerRe: Manage audio and video files Pin
PSK_14-May-07 20:32
PSK_14-May-07 20:32 
GeneralRe: Manage audio and video files Pin
Rahul Babu14-May-07 21:26
Rahul Babu14-May-07 21:26 
GeneralRe: Manage audio and video files Pin
SimulationofSai14-May-07 22:57
SimulationofSai14-May-07 22:57 
QuestionPrint a page without prompting Print dialog Pin
Elena200614-May-07 19:13
Elena200614-May-07 19:13 
AnswerRe: Print a page without prompting Print dialog Pin
PSK_14-May-07 20:18
PSK_14-May-07 20:18 
AnswerRe: Print a page without prompting Print dialog Pin
Guffa14-May-07 21:45
Guffa14-May-07 21:45 
GeneralRe: Print a page without prompting Print dialog Pin
Elena200614-May-07 23:11
Elena200614-May-07 23:11 
AnswerRe: Print a page without prompting Print dialog Pin
Guffa15-May-07 1:20
Guffa15-May-07 1:20 
AnswerRe: Print a page without prompting Print dialog Pin
Member 425754114-Apr-10 20:17
Member 425754114-Apr-10 20:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.