|
faladrim wrote: i used the wizard apply in from the toolbar datagrid vs2005
OK - It's quite posible that when you clicked "Finish" when you created the datatable, VS2005 didn't create all the commands - including the delete command. Open your ????DataSet.xsd file and highlight the datatable that is giving you problems. Right click it and select Configure. Go thru each step till the end and make sure the wizard has generated all the commands for you - there are 8 of them including the delete command. If it hasn't then you have either not configured the SELECT command properly (it's the command that the wizard uses to base it's generation of the other commands)or the tableadapter is having problems with the database's table itself.
The following snippet of code may also help:
<br />
for (int i = 0; i < foundRows.Length; i++)<br />
{<br />
foundRows[i].Delete();<br />
}<br />
this.meetingsAttendanceTableAdapter.Update(this.myclubDataSet.MeetingsAttendance);<br />
this.myclubDataSet.AcceptChanges();<br />
Let me know how you go 
Glen Harvy
|
|
|
|
|
lo,
i inserted a deletecommand with commandtext DELETE FROM tabel1, but if i select a row in my program and press the delete button, everything is deleted; is there something wrong in my code?
i thought that i specifed the nummer of the row and that this one was deleted.
DataRow selectedrow = db1DataSet.tabel1.Rows[dataGridView1.CurrentRow.Index ];
selectedrow.Delete();
// apply delete to the database
try
{
tabel1TableAdapter.Update(db1DataSet.tabel1);
db1DataSet.AcceptChanges();
// refresh after the delete
this.tabel1TableAdapter.Fill(this.db1DataSet.tabel1);
Application.DoEvents();
}
catch (System.Exception ex)
{
db1DataSet.RejectChanges();
lbl_error.Text= ex.Message;
}
-- modified at 5:04 Monday 18th September, 2006
|
|
|
|
|
faladrim wrote: i inserted a deletecommand with commandtext DELETE FROM tabel1, but if i select a row in my program and press the delete button, everything is deleted; is there something wrong in my code?
I assume that you have NOT created an oldedb/sql command to delete anything and that the only code in your file that relates to this is the code you have quoted.
I presume that the "on_click" for the button has no other code besides the code you have quoted.
I would change your code as follows:
<br />
try<br />
{<br />
DataRow selectedrow = db1DataSet.tabel1.Rows[dataGridView1.CurrentRow.Index ]; <br />
selectedrow.Delete();<br />
tabel1TableAdapter.Update(db1DataSet.tabel1);<br />
db1DataSet.AcceptChanges();<br />
this.tabel1TableAdapter.Fill(this.db1DataSet.tabel1);<br />
}<br />
catch (System.Exception ex)<br />
{<br />
db1DataSet.RejectChanges();<br />
lbl_error.Text= ex.Message;<br />
}<br />
I think any problems with any of your code will now be revealed.
Let me know how you go.
Glen Harvy
|
|
|
|
|
faladrim wrote: i inserted a deletecommand with commandtext DELETE FROM tabel1,
I assume that you have NOT created an oldedb/sql command to delete anything and that the only code in your file that relates to this problem is the code you have quoted.
I presume that the "on_click" for the button has no other code besides the code you have quoted.
I would change your code as follows:
// apply delete to the database
try
{
DataRow selectedrow = db1DataSet.tabel1.Rows[dataGridView1.CurrentRow.Index ];
selectedrow.Delete();
tabel1TableAdapter.Update(db1DataSet.tabel1);
db1DataSet.AcceptChanges();
// refresh after the delete
this.tabel1TableAdapter.Fill(this.db1DataSet.tabel1);
}
catch (System.Exception ex)
{
db1DataSet.RejectChanges();
lbl_error.Text= ex.Message;
}
I think any problems with any of your code will now be revealed. If you have any problems please quote the whole error message you get.
Let me know how you go.
Glen Harvy
Glen Harvy
|
|
|
|
|
lo,
i have no error messages at all,
but my whole table is deleted and not the one i selected
so i thought it was because of the datarow selectedrow.... code line
i changed it to db1DataSet.tabel1.Rows[dataGridView1.CurrentRow.Index].Delete();
witch does the same
so i still get an emty grid after wiching to delete just one
i am pretty sure that my commandtext is wrong,
heres what i did:
i opened the db1Dataset.xsd
looked into the property screen right-below and changed deletecommand from none to new
and entered in the commandtext: delete from tabel1
thx for the help 
grz
|
|
|
|
|
The problem is in the tableAdapter.
Go back into the db1DataSet.xsd and delete the adapter.
Use the wizard and let it create ALL the commands - basically just accept the defaults as you go thru the wizard. There should only be a FillBy in the properties and nothing else - the other commands are "hidden".
There is no need for you to manually create any of the update, delete etc commands.
Then try running your program again.
Glen Harvy
|
|
|
|
|
then i get the error i started with cause there is no delete command
this is what i just did cause there most be something going wrong:
i sleceted everything in dataset.xsd en deleted it
right click add tableadapter
wizard new connection and choose my connection = access database and his folder -> next
the only thing that i can highlight is use sql statements -> next
query bluilder choose my table, Select tabel1.* from tabel1, -> ok and -> next
3 things highlighted: fill datatable method name = fill, return a datatable method name = getdata, create method... and no method name -> next
configure succesful, and a list of the generated items :
SELECT, INSERT, table mappings, FILL, GET, UPDATE ->finish
so i dont have delete
what did i do wrong?
grz
|
|
|
|
|
Well - you have now found the location of your problem .
I have had the same situation before and found the problem was in my SELECT statement.
Highlight the dataTable and run the Configure wizard again. When you get to the actual place where you insert the SELECT Statement click on the Advanced button and make sure both options are ticked.
Change the statement to SELECT * FROM TABLE1.
Open the Query Builder and run Execute Query to make sure it works.
Continue with the wizard.
If the Delete Command still doesn't appear at the end of the Wizard BUT the Query worked OK when you ran it above then click REBUILD on your project. Close the project and then re-open it. Go through all the above again.
Be mindfull of your select statement and how it's worded. For example, Date fields need to be enclosed in [ ]. A DELETE statement (it's not a command by the way) can only be generated if the Database and the Select statement are designed to allow it to be created by the wizard.
There are quite a few bugs in VS2005 which I've found over the past 3 months and whilst the closing and reopening of VS2005 (not just the project) doesn't make sense it has fixed some of my problems.
Glen Harvy
|
|
|
|
|
stil the same problem 
is it possible in access to make sure u cant delete? i didnt think so
|
|
|
|
|
lo, i have made it work by entering the next text in the commandtext:
delete from tabel1 where name = ? or address= ?
name and address are my collums, but this is not the answer, because in the futur the user of the programs is able to add a collum but with this he cant delete a row
something to think about hé
grz
|
|
|
|
|
This is where you are confused or you are confusing us:
There are two ways of manipulating your table in the database. One is in a connected state and the other is in a disconnected state.
A connected state is where you open your connection, run a command, and close your connection. Forget about rows and datgrids and IDE wizards, you are directly changing the table just the same as if you were using MS Access etc. It's here that you create your commands and why your latest attempt works.
A disconnected state is where you use a dataAdapter which connects to the database and loads the table into RAM. You then use the bindingsource (rows.delete etc) statements to manipulate the data in RAM. When you are finished playing around you call the adapter to "update" or transfer all the changes you have made in RAM back to the table in the database. The commands contained in the dataAdapter are hidden from you because you never need to amend or change them.
From what you are saying then it appears you are using BOTH methods and trying to mix them at the same time.
Glen Harvy
|
|
|
|
|
aha now i see the differt,
but that doesnt change why i cant use the disconnected state allone
|
|
|
|
|
The question is - why isn't the wizard creating the Delete statement.
I need to think about it and will get back to you if I can come up with some suggestions. It's 10:00 pm here so I might not get back to you tonight
Now you know where the problem is though, I suggest you now post another Message and see if there is anyone else out there that can help you with an answer.
Glen Harvy
|
|
|
|
|
In my application there are four pages (Page1, Page2, Page3 and Page4). Each page have some basic controls and Web grids and also a “Save” button.
If I click on a “Save” button from any page all four pages data is saved to Database. Please give me guidance / suggestions how I can solve this. If you send a sample code its great. I am using Asp.net 2.0, C# and Sql Server 2005.
thank u
pradeep varma m
|
|
|
|
|
you could raise the click-event of the other buttons.
you would have to add something like
<br />
btnSavePage2.Click(null, null);<br />
btnSavePage3.Click(null, null);<br />
btnSavePage4.Click(null, null);<br />
to the click code for the save button on page 1 and something like this
<br />
btnSavePage1.Click(null, null);<br />
btnSavePage3.Click(null, null);<br />
btnSavePage4.Click(null, null);<br />
for the button on page 2. the click event is raised when a user clicks on the button. since you would emulate it this way, the user would click all of the buttons instead of one.
|
|
|
|
|
Thanks for your reply. But my requirement is: In my application there are four pages (Page1, Page2, Page3 and Page4). Each page have some basic controls and Web grids and also a “Save” button.
If I click on a “Save” button(only once) from any page all four pages data is saved to Database. Please give me guidance / suggestions how I can solve this. If you send a sample code its great. I am using Asp.net 2.0, C# and Sql Server 2005.
thank u
pradeep varma m
|
|
|
|
|
ah okay, you want people to do the whole work for you? good luck
|
|
|
|
|
The ASP.NET forum is more suitable for this kind of question.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
I think you haven't understood my question. I don't want to click all the buttons.
Thanks,
|
|
|
|
|
i think i understood it now. you want someone to write the whole database interface for you and then write the source code for your program. right? as already said in the other reply: good luck!
|
|
|
|
|
Hi Friends,
I facing a problem. I have two submit button in a page.
if i click any button, page is going to submit and first it will execute page_load event.
But my problem is - In page load event i have to identify whether page is submited by clicking of Button1 or By clicking of button2.
(Because i have call different function based on button1/button2)
|
|
|
|
|
when you call the page_load event, use the current button as the sender parameter, the in the page_load, cast the sender back to the button and and check which one it was.
e.g.
<br />
button1click()<br />
{<br />
this.load( button1, EventArgs.Empty );<br />
...<br />
}<br />
<br />
button2click()<br />
{<br />
this.load( button2, EventArgs.Empty );<br />
...<br />
}<br />
<br />
pageLoad( object sender, EventArgs e )<br />
{<br />
Buttom clicked = (Button)sender;<br />
<br />
if( clicked == button1 )<br />
{<br />
...<br />
}<br />
else( clicked == button2 )<br />
{<br />
...<br />
}<br />
}<br />
|
|
|
|
|
It's giving me error " System.InvalidCastException: Specified cast is not valid." on "Button clicked = (Button)sender;"
|
|
|
|
|
sorry.
try calling the method directly instead of calling the event (not the best way to do things, but should solve the problem).
e.g.
button1click()
{
pageLoad( button1, EventArgs.Empty );
...
}
|
|
|
|
|
Thanks for reply.
Can i use Javascript to set hidden variable?
Can i use session variable?
can you guid me which could be worthy to use? If possible give sample code becuase i am new to ASP.Net.
Thanks,
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
