Click here to Skip to main content
15,743,179 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionfor project titles Pin
vvikram16-Apr-09 11:58
vvikram16-Apr-09 11:58 
AnswerRe: for project titles Pin
Yusuf16-Apr-09 12:40
Yusuf16-Apr-09 12:40 
AnswerRe: for project titles Pin
Christian Graus16-Apr-09 14:11
protectorChristian Graus16-Apr-09 14:11 
GeneralRe: for project titles Pin
MidwestLimey17-Apr-09 9:17
professionalMidwestLimey17-Apr-09 9:17 
AnswerRe: for project titles Pin
Abhijit Jana16-Apr-09 20:09
professionalAbhijit Jana16-Apr-09 20:09 
QuestionGridview refresh from popup window Pin
bitsbuilt16-Apr-09 11:47
bitsbuilt16-Apr-09 11:47 
AnswerRe: Gridview refresh from popup window Pin
Christian Graus16-Apr-09 11:53
protectorChristian Graus16-Apr-09 11:53 
Questionexcel -sql server ? Pin
haseeb_saeed16-Apr-09 11:15
haseeb_saeed16-Apr-09 11:15 
I have an excel file and want to copy data to sql server. The excel file has a field name: device name , and a field named: model...(there are 30 more fields)
deviceName model
laptop acer 1640
laptop fujitsu
laptop sony
notebook ibm
laptop ibm.

I need to transfer these files into the sql server database. i know that i require 2 tables in sql with one table for devices and another for models and both should have a relationship of M:N. hence another table is required.

My question is that is there any easy way of doin this in sql server or do i have to program it... I have searched regarding dts and it seems that dts works well when only one table has to be transtered to one table. there is a possibility that dts does it but i don't know how to develop scripts in dts as i am an asp.net developer. Do i have to find a way out using C# or are there any tools that solve such problems

any help will highly appreciated.
thanx

haseeb

AnswerRe: excel -sql server ? Pin
Christian Graus16-Apr-09 11:54
protectorChristian Graus16-Apr-09 11:54 
GeneralRe: excel -sql server ? Pin
haseeb_saeed16-Apr-09 12:44
haseeb_saeed16-Apr-09 12:44 
GeneralRe: excel -sql server ? Pin
Christian Graus16-Apr-09 14:14
protectorChristian Graus16-Apr-09 14:14 
GeneralRe: excel -sql server ? Pin
haseeb_saeed16-Apr-09 16:21
haseeb_saeed16-Apr-09 16:21 
AnswerRe: STOP cross-posting Pin
Yusuf16-Apr-09 12:42
Yusuf16-Apr-09 12:42 
GeneralRe: STOP cross-posting Pin
haseeb_saeed16-Apr-09 16:30
haseeb_saeed16-Apr-09 16:30 
GeneralRe: STOP cross-posting Pin
Yusuf16-Apr-09 16:49
Yusuf16-Apr-09 16:49 
GeneralRe: STOP cross-posting Pin
Christian Graus16-Apr-09 16:52
protectorChristian Graus16-Apr-09 16:52 
QuestionLabel in requiredvalidatorcontrol is not showing up in page load Pin
vmang16-Apr-09 11:08
vmang16-Apr-09 11:08 
AnswerRe: Label in requiredvalidatorcontrol is not showing up in page load Pin
Christian Graus16-Apr-09 11:54
protectorChristian Graus16-Apr-09 11:54 
AnswerRe: Label in requiredvalidatorcontrol is not showing up in page load Pin
archit300020-Apr-09 1:56
archit300020-Apr-09 1:56 
QuestionHow to set Crystal Report datasource to an XML file Pin
David Mujica16-Apr-09 9:01
David Mujica16-Apr-09 9:01 
QuestionMultiple monitor Pin
SUDHAKAR PALLAM16-Apr-09 6:57
SUDHAKAR PALLAM16-Apr-09 6:57 
AnswerRe: Multiple monitor Pin
Yusuf16-Apr-09 7:29
Yusuf16-Apr-09 7:29 
QuestionRe: Multiple monitor Pin
sara malik16-Apr-09 7:59
sara malik16-Apr-09 7:59 
AnswerRe: Multiple monitor Pin
SUDHAKAR PALLAM16-Apr-09 17:09
SUDHAKAR PALLAM16-Apr-09 17:09 
AnswerRe: Multiple monitor Pin
Christian Graus16-Apr-09 11:56
protectorChristian Graus16-Apr-09 11:56 

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.