473,509 Members | 8,693 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

help me plz

2 New Member
hey i got an errror in my program can u help me..................

using system.data;
using system.data.sqlclient;

sqlconnection con;
sqlcommand cmd;
slqdataadapter da;
dataset ds;

pageload
{
sqlconnection con=new sqlconnection("server=.;database=employee;uid=sa") ;
con.open();

sqlcommand cmd=new sqlcommand("select * from emp",con);
da=new sqldataadapter(cmd);
ds=new dataset();
da.fill(ds,"emp");
gridview1.datasource=ds.table["emp"];
gridview1.databind();
}

btninsert_click
{
sqlcommand cmd=new sqlcommand("insert into emp values('"+ TextBox1.Text +"','"+ TextBox2.Text +"',con);
cmd.executenonquery();
displaydata();
clear()
}


the exception is given below.

System.InvalidOperationException: Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition.


can any help me to solve this
Mar 13 '08 #1
3 1611
Stang02GT
1,208 Recognized Expert Top Contributor
Your going to have to give us more detail about this code and what it is supposed to do.


It appears once we get more information this would be more suited in the SQL forums
Mar 13 '08 #2
arunr2008
1 New Member
You have specified the datasource both in the design time and the code-behind(run-time). You need to remove either of these two.

Other wise you try with following code:-

GridView1.DataSource = ds;
GridView1.DataSourceID = String.Empty;
Mar 14 '08 #3
smruti
6 New Member
[quote=jeronjaison]hey i got an errror in my program can u help me..................

using system.data;
using system.data.sqlclient;

sqlconnection con;
sqlcommand cmd;
slqdataadapter da;
dataset ds;

pageload
{
sqlconnection con=new sqlconnection("server=.;database=employee;uid=sa") ;
con.open();

sqlcommand cmd=new sqlcommand("select * from emp",con);
da=new sqldataadapter(cmd);
ds=new dataset();
da.fill(ds,"emp");
gridview1.datasource=ds.table["emp"];
gridview1.databind();
}

btninsert_click
{
sqlcommand cmd=new sqlcommand("insert into emp values(+"','"+ TextBox2.Text +"',con);
cmd.executenonquery();
displaydata();
clear()
}


the exception is given below.

System.InvalidOperationException: Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition.
Mar 18 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

21
6489
by: Dave | last post by:
After following Microsofts admonition to reformat my system before doing a final compilation of my app I got many warnings/errors upon compiling an rtf file created in word. I used the Help...
9
4377
by: Tom | last post by:
A question for gui application programmers. . . I 've got some GUI programs, written in Python/wxPython, and I've got a help button and a help menu item. Also, I've got a compiled file made with...
6
4305
by: wukexin | last post by:
Help me, good men. I find mang books that introduce bit "mang header files",they talk too bit,in fact it is my too fool, I don't learn it, I have do a test program, but I have no correct doing...
3
3326
by: Colin J. Williams | last post by:
Python advertises some basic service: C:\Python24>python Python 2.4.1 (#65, Mar 30 2005, 09:13:57) on win32 Type "help", "copyright", "credits" or "license" for more information. >>> With...
7
5344
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting list. But there isn't any information available...
5
3249
by: Steve | last post by:
I have written a help file (chm) for a DLL and referenced it using Help.ShowHelp My expectation is that a developer using my DLL would be able to access this help file during his development time...
8
3206
by: Mark | last post by:
I have loaded Visual Studio .net on my home computer and my laptop, but my home computer has an abbreviated help screen not 2% of the help on my laptop. All the settings look the same on both...
10
3328
by: JonathanOrlev | last post by:
Hello everybody, I wrote this comment in another message of mine, but decided to post it again as a standalone message. I think that Microsoft's Office 2003 help system is horrible, probably...
1
6112
by: trunxnirvana007 | last post by:
'UPGRADE_WARNING: Array has a new behavior. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="9B7D5ADD-D8FE-4819-A36C-6DEDAF088CC7"' 'UPGRADE_WARNING: Couldn't resolve...
0
2849
by: hitencontractor | last post by:
I am working on .NET Version 2003 making an SDI application that calls MS Excel 2003. I added a menu item called "MyApp Help" in the end of the menu bar to show Help-> About. The application...
0
7237
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
1
7073
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7506
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5062
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4732
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3218
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3207
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
779
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
443
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.