Click here to Skip to main content
15,907,910 members
Home / Discussions / C#
   

C#

 
QuestionHow I get Microsoft excel range object which contain merged cells with c# Pin
Old Gun17-Apr-06 20:51
Old Gun17-Apr-06 20:51 
Questionhow can i create document for my dll Pin
iman_kh17-Apr-06 20:34
iman_kh17-Apr-06 20:34 
AnswerRe: how can i create document for my dll Pin
alexey N17-Apr-06 20:41
alexey N17-Apr-06 20:41 
Questionwithevents in c# Pin
abhinish17-Apr-06 20:22
abhinish17-Apr-06 20:22 
AnswerRe: withevents in c# Pin
Christian Graus17-Apr-06 20:40
protectorChristian Graus17-Apr-06 20:40 
AnswerRe: withevents in c# Pin
HimaBindu Vejella17-Apr-06 23:32
HimaBindu Vejella17-Apr-06 23:32 
Questionimporting excel data to sql server Pin
genx_code17-Apr-06 20:20
genx_code17-Apr-06 20:20 
AnswerRe: importing excel data to sql server Pin
Monin D.17-Apr-06 21:13
Monin D.17-Apr-06 21:13 
You can use the Odbc driver[^]. I do it often so:
1. Save your worksheet to csv file format but it must be looking like a table
field_name1 | field_name2 | field_name3
---------------------------------------
values      | values      | values


2. In your application you write
using Microsoft.Data.Odbc;
using System.Data;

....some code...

DataTable dt = new DataTable();
OdbcDataAdapter adapter;
OdbcConnection csvDB;

csvDB = new OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)}; Readonly=true;DBQ=[dir where is your file]");
adapter = new OdbcDataAdapter("SELECT * FROM [filename].csv", csvDB);
adapter.Fill(dt);

3.
foreach(DataRow dr in dt.Rows)
{
    .....
    with INSERT queries put it to your SQL DB.
}

GeneralRe: importing excel data to sql server Pin
genx_code18-Apr-06 16:34
genx_code18-Apr-06 16:34 
AnswerRe: importing excel data to sql server Pin
HimaBindu Vejella17-Apr-06 23:55
HimaBindu Vejella17-Apr-06 23:55 
Questiondynamic html page creation using javascript Pin
umaheshchandra17-Apr-06 20:17
umaheshchandra17-Apr-06 20:17 
AnswerRe: dynamic html page creation using javascript Pin
alexey N17-Apr-06 20:28
alexey N17-Apr-06 20:28 
QuestionHTML To PDF File Pin
bging17-Apr-06 19:58
bging17-Apr-06 19:58 
Questionto get the font style of a character Pin
janarthanreddy17-Apr-06 19:44
janarthanreddy17-Apr-06 19:44 
QuestionMerging Of Multiple Activex Wrapper Dll Into Single Assembly Pin
vighnesha17-Apr-06 19:31
vighnesha17-Apr-06 19:31 
AnswerRe: Merging Of Multiple Activex Wrapper Dll Into Single Assembly Pin
Jakob Farian Krarup17-Apr-06 19:38
Jakob Farian Krarup17-Apr-06 19:38 
GeneralRe: Merging Of Multiple Activex Wrapper Dll Into Single Assembly Pin
vighnesha17-Apr-06 20:42
vighnesha17-Apr-06 20:42 
QuestionSuggest me for Data Migration tools Pin
mahesh_magham17-Apr-06 18:22
mahesh_magham17-Apr-06 18:22 
Questionhow to get all windows that are programs Pin
g00fyman17-Apr-06 18:18
g00fyman17-Apr-06 18:18 
AnswerRe: how to get all windows that are programs Pin
alexey N17-Apr-06 18:58
alexey N17-Apr-06 18:58 
GeneralRe: how to get all windows that are programs Pin
g00fyman17-Apr-06 19:19
g00fyman17-Apr-06 19:19 
GeneralRe: how to get all windows that are programs Pin
g00fyman17-Apr-06 19:42
g00fyman17-Apr-06 19:42 
Questionstatic question Pin
Old Gun17-Apr-06 18:04
Old Gun17-Apr-06 18:04 
AnswerRe: static question Pin
alexey N17-Apr-06 18:10
alexey N17-Apr-06 18:10 
GeneralRe: static question Pin
Old Gun17-Apr-06 19:01
Old Gun17-Apr-06 19:01 

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.