|
hello
when I hit the delete button in BindingNavigator1 the update method of tableadapter give me this error.
"Update requires a valid DeleteCommand when passed DataRow collection with deleted rows"
how can i delete my data that be deleted in my database(SQL 2005).
thanks for your help
|
|
|
|
|
It's telling you that it doesn't know how to delete the data in your database because you haven't supplied an SqlCommand to do the delete. How are you setting up your DataAdapter to get the data?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I drag my object(textbox from dataset) form myconnection and VB.Net add the bindingnavigator,tableadapter,bindingsource.
i didn't use it it use automatically.
how can i supplied an SqlCommand delete my data from database
thanks for your answer and help
|
|
|
|
|
Does your database table have a primary key? If not, there's no way for the Delete command to uniquely find each record to delete it.
Also, I find supporting the Designed generated code to be a huge problem. Writing the code yourself gives you a much greater control over the data process and makes it much easier to support since you can actually find the code.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
theatre booking with minimum 200 text boxes on form and maximum 600 text boxes, as seats looking for code for this to say whether the seats are booked or free as with multi dimensional array the code that is generated for each txt box would be phenomanal looking for easy way than that at present using tab index to code the programme.
|
|
|
|
|
kendo17 wrote: as with multi dimensional array
Why not just use a multi-dimensional array? Also try looping through all the controls of the type textbox in your form.
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
would generate mass amount of code for just 1 text box.
|
|
|
|
|
I don't think you need to put any code in any event of the text box. like evilnoodle said, use the control collection
you didn't specify what you wanted done when you found a free seat so the below just finds the first free textbox...
For each oCtrl as me.controls
if typeof (octrl) is textbox then
with ctype(octrl, textbox)
if .text = "free" then
.focus()
exit for
end if
end with
end if
next
|
|
|
|
|
kendo17 wrote: minimum 200 text boxes on form and maximum 600 text boxes
You really need to rethink this. If I saw an application that did this, I recommend to the customer that they uninstall it and finding a different solution provider.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i have a form with a list that shows thumbnails of many jpg pictures.
i works with a loop, that looks through the paths of the jpgs from a database, and adds the image to a image list, then adds the item into the list with the corresponding image.
works fine.
the problem is, that loading the images delays the program execution, and so I've made it into a "please wait" dialog, but still its quite slow.
how can i create a method that loads the list without the images, and then, without pausing execution, (i.e. in the background) loads the images (into the image list) one by one.
I've tried a few ways, some work but it's very inefficient 
thank you in advance
Ericos Georgiades
|
|
|
|
|
You'll have to move your image loading code to a background thread. There's many examples of using the BackgroundWorker component. All you have to do is Google for it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i've already tried a background worker, yet i guess i need to time it better or work on the code
cause it loads them and if you touch one unloaded it ruins certain things (guess i'd just disable them
at first)
thank you, guess i was waiting for a diffrent approach but this is probably the best way
Ericos Georgiades
|
|
|
|
|
1) use a databound listbox and get the records from the database and set the datasource to the result
2) look into "threading" to load behind the scenes.
|
|
|
|
|
if i set the datasource on the listbox (haven't tried it) then how do i get to load jpgs into it?
i didn't think i could, i'll give it a try (with a databound imagelist aswell?) thanks
Ericos Georgiades
|
|
|
|
|
1) load the listbox
2) then use the same dataset to load the images.
|
|
|
|
|
I would like your help with the following
I have drawn an ellipse(fillellipse...)
i would like to have control on that ellipse, means when pressing on the drwan ellipse(mouse Hover) (do action....)
i thought of the following :
how to : Change the Panel Control to a Button (how to do that)??
is there any other way of thinkin
Regards
Ramy
|
|
|
|
|
charchabil03 wrote: how to : Change the Panel Control to a Button (how to do that)??
If your asking how to convert a Panel class to a Button, you can't.
If you're asking how to treat the Panel link a button, all you have to do is handle the Panel's Click event.
What are you really trying to do with this???
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
first thx for answering
I have drawn an ellipse (fillellipse)
all waht i want to handle the click event of that drwan ellipse
Regards
Ramy
|
|
|
|
|
The ellipse isn't a clickable object. It's only a picture drawn on the surface of another control.
I think I know what you're after. Something like a paint application where you can select the various object you've drawn, like lines, rectangles, and circles, and move them around after you've drawn them.
If this is true, you've gotten yourself into a fairly large application. An example of which you can find here[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave Kreskowiak wrote: The ellipse isn't a clickable object. It's only a picture drawn on the surface of another control.
Yes i know that
I found the following
else if(control is System.Windows.Forms.Button)<br />
{<br />
Button button = (Button)control;<br />
<br />
button.Text = "";<br />
<br />
button.Cursor = Cursors.Hand;
the aboce as u notice is written with C#
can you help to modify it ,and write in vb.net 2005?
i have drwan many ellipse.and all waht i want is to be able to click on that drwan ellipse,when the user clicks on ellipse1 do action 1.if he click on ellipse2 do action2....
Thx
Regards
Ramy
|
|
|
|
|
How do I set my databound form controls to contain the same default values as specified by my database? So that I don't get "does not allow NULL" errors when adding and saving a new record.
According to me the controls are properly bound by bindingsource - the works.
(VS2005 & SQL2000)
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
Before you add a new row to your DataTable control you should set the .DefaultValue of each column in that DataTable. Personally, I always set my DefaultValues to an empty string if it is a text column, and a zero if it a numeric column. To do this, I use this method in my global module:
Public Sub SetDefaultValues(ByRef dt As DataTable)<br />
For Each colColumn As DataColumn In dt.Columns<br />
Select Case colColumn.DataType.FullName<br />
Case "System.String"<br />
colColumn.DefaultValue = String.Empty<br />
Case "System.Decimal"<br />
colColumn.DefaultValue = 0<br />
End Select<br />
Next<br />
End Sub
Hope this helps.
|
|
|
|
|
Can anyone one give me an example to make application that can get Username and password when user use yahoo messenger,....
Thanks
................
|
|
|
|
|
That's a really broad question, more the sort of thing you'd ask on a paid site. I presume that yahoo wouldn't expose that information, I'd sure hope not. I can't think of why you'd want it, except to steal someone's account. And that would be bad.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
NO, I just want know the proscess
................
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
