Hi, when i'm importing Excel data to SQL table it commits some error "xxx". I want to fetch that error from import and export wizard and i want to show that error in some textbox in .net.
For E.g.
In Excel,
I have 2 columns Name and Branch
Name Branch
aaa ppp
bbb
ccc rrr
In SQL table,
I have same 2 columns Name(varchar(50),not null) and Branch(varchar(50),not null)
While importing 1st row inserted into SQL table, 2nd and 3rd rows are not inserted because of 2nd row and 2nd column empty
That import and export wizard shows error messages like "The value violated the integrity contrainst for the column"
hari.infotec...
Member
29 Points
90 Posts
how to show error message from import and export wizard in .net
Nov 19, 2012 01:20 PM|LINK
Hi, when i'm importing Excel data to SQL table it commits some error "xxx". I want to fetch that error from import and export wizard and i want to show that error in some textbox in .net.
For E.g.
In Excel,
I have 2 columns Name and Branch
Name Branch
aaa ppp
bbb
ccc rrr
In SQL table,
I have same 2 columns Name(varchar(50),not null) and Branch(varchar(50),not null)
While importing 1st row inserted into SQL table, 2nd and 3rd rows are not inserted because of 2nd row and 2nd column empty
That import and export wizard shows error messages like "The value violated the integrity contrainst for the column"
I want to show that message in textbox in .net
I'm waiting
Chen Yu - MS...
All-Star
21584 Points
2493 Posts
Microsoft
Re: how to show error message from import and export wizard in .net
Nov 22, 2012 09:22 AM|LINK
Hi,
Do you means you use Import and export wizard in your project?
Best Regards,
Feedback to us
Develop and promote your apps in Windows Store
hari.infotec...
Member
29 Points
90 Posts
Re: how to show error message from import and export wizard in .net
Nov 28, 2012 11:48 AM|LINK
sorry for the late rply. yes i meant to use Import and export wizard in my project.
I used Import and Export data(32 bit) in MS SQL Server 2008