Click here to Skip to main content
15,908,013 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Personality Profilling with ASP.NET? Pin
Krazy Programmer25-Apr-08 6:08
Krazy Programmer25-Apr-08 6:08 
JokeRe: Personality Profilling with ASP.NET? Pin
Taurian11025-Apr-08 9:27
Taurian11025-Apr-08 9:27 
QuestionChanging Date Format Pin
munklefish25-Apr-08 4:40
munklefish25-Apr-08 4:40 
GeneralRe: Changing Date Format Pin
Taurian11025-Apr-08 5:25
Taurian11025-Apr-08 5:25 
GeneralRe: Changing Date Format Pin
Blue_Boy25-Apr-08 9:17
Blue_Boy25-Apr-08 9:17 
GeneralRe: Changing Date Format Pin
munklefish28-Apr-08 0:24
munklefish28-Apr-08 0:24 
GeneralRe: Changing Date Format Pin
Blue_Boy28-Apr-08 0:45
Blue_Boy28-Apr-08 0:45 
GeneralRe: Changing Date Format Pin
munklefish28-Apr-08 0:50
munklefish28-Apr-08 0:50 
SQL 2005

Although im trying to do the convert on when uploading an Excel sheet to SQL2005 using BulkCopy.

See below:

<code>protected void Page_Load(object sender, EventArgs e)
{
// Connection String to Excel Workbook
//string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BLAH\qs_upload.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BLAH\qs_upload.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

// Create Connection to Excel Workbook
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
{
OleDbCommand command = new OleDbCommand("Select * FROM [quality_standard$]", connection);
//OleDbCommand command = new OleDbCommand("Select qs_Id, qs_Organisation, Convert(varchar,qs_Start,111), qs_End FROM [quality_standard$]", connection);

connection.Open();

// Create DbDataReader to Data Worksheet
using (OleDbDataReader dr = command.ExecuteReader())
{
// SQL Server Connection String
string sqlConnectionString = "REMOVED"

// Bulk Copy to SQL Server
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString))
{
bulkCopy.DestinationTableName = "tbl_QualityStandard";
bulkCopy.WriteToServer(dr);
}
}
}
}</code>
GeneralDiv inside another div not sizing correctly in the user control Pin
gottimukkala25-Apr-08 4:14
gottimukkala25-Apr-08 4:14 
GeneralRe: Div inside another div not sizing correctly in the user control Pin
Taurian11025-Apr-08 5:04
Taurian11025-Apr-08 5:04 
GeneralRe: Div inside another div not sizing correctly in the user control Pin
gottimukkala25-Apr-08 5:17
gottimukkala25-Apr-08 5:17 
GeneralRe: Div inside another div not sizing correctly in the user control Pin
Taurian11025-Apr-08 5:19
Taurian11025-Apr-08 5:19 
GeneralRe: Div inside another div not sizing correctly in the user control Pin
gottimukkala25-Apr-08 5:36
gottimukkala25-Apr-08 5:36 
QuestionNeed help with passing value via OnCheckedChanged event [modified] Pin
the_0live25-Apr-08 4:03
the_0live25-Apr-08 4:03 
GeneralRe: Need help with passing value via OnCheckedChanged event Pin
AlexeiXX325-Apr-08 14:07
AlexeiXX325-Apr-08 14:07 
GeneralRe: Need help with passing value via OnCheckedChanged event Pin
the_0live28-Apr-08 2:28
the_0live28-Apr-08 2:28 
GeneralRe: Need help with passing value via OnCheckedChanged event Pin
the_0live6-May-08 3:45
the_0live6-May-08 3:45 
QuestionHow to get hardcoded data to xml and that xml can be used in .Net Pin
subbu.sk25-Apr-08 2:39
subbu.sk25-Apr-08 2:39 
AnswerRe: How to get hardcoded data to xml and that xml can be used in .Net Pin
eyeseetee25-Apr-08 2:42
eyeseetee25-Apr-08 2:42 
GeneralProblume With Excel sheet Pin
santoshkomarraju25-Apr-08 2:36
santoshkomarraju25-Apr-08 2:36 
QuestionI have an error :'System.Web.UI.WebControls.GridView.Rows' is a 'property' but is used like a 'method' Pin
Saba0225-Apr-08 2:33
Saba0225-Apr-08 2:33 
QuestionRe: I have an error :'System.Web.UI.WebControls.GridView.Rows' is a 'property' but is used like a 'method' Pin
Vasudevan Deepak Kumar25-Apr-08 2:35
Vasudevan Deepak Kumar25-Apr-08 2:35 
GeneralRe: I have an error :'System.Web.UI.WebControls.GridView.Rows' is a 'property' but is used like a 'method' Pin
eyeseetee25-Apr-08 2:47
eyeseetee25-Apr-08 2:47 
GeneralRe: I have an error :'System.Web.UI.WebControls.GridView.Rows' is a 'property' but is used like a 'method' Pin
AlexeiXX325-Apr-08 5:42
AlexeiXX325-Apr-08 5:42 
GeneralUse One datalist into another Pin
raushan_925-Apr-08 1:42
raushan_925-Apr-08 1:42 

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.