Re: Loading sql record into a variable - Visual Basic Discussion Boards

tazbird9-Jul-07 11:28

9-Jul-07 11:28

Hi all!

I'm sure there’s a commonly well known way to do this, but after days of googling and googling I can't seem to find a procedure.

I have an application the works with a SQL database, I want it to work with the data in a specific field, and then return that value to the database.

Where I'm stuck is that I can't figure out how to set a variable = to the data in a specific field.

Can someone please outline what I need to do, or point me to a specific tutorial?

Thanks for any help!

--Derek

Re: Loading sql record into a variable

Luc Pattyn9-Jul-07 11:52

Luc Pattyn

9-Jul-07 11:52

instead of googling for days, spend a couple of hours reading some of the
excellent articles here on CodeProject (I am not saying they are all
excellent, but there are some bloody good ones !). There is a search facility
at the top of most pages on CodeProject.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Loading sql record into a variable

MidwestLimey9-Jul-07 12:49

MidwestLimey

9-Jul-07 12:49

I think you forgot something ...

finally { appropriateForum.Post(message); }

I'm largely language agnostic  
     After a while they all bug me  

Re: Loading sql record into a variable

Luc Pattyn9-Jul-07 13:09

Luc Pattyn

9-Jul-07 13:09

no no, finally block gets executed no matter what, and that is not required once
you found a solution somewhere.

Furthermore it would exceed the allowed 500 char maximum for a sig.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Loading sql record into a variable

MidwestLimey10-Jul-07 4:45

MidwestLimey

10-Jul-07 4:45

I realised the second I posted it. Shame, in english it sounds good. C# not so much.

I'm largely language agnostic  
     After a while they all bug me  

Re: Loading sql record into a variable

MidwestLimey9-Jul-07 12:51

MidwestLimey

9-Jul-07 12:51

Well, strickly speaking it shouldn't be finally but I had a geek attack. End of the day.

I'm largely language agnostic  
     After a while they all bug me  

Re: Loading sql record into a variable

tazbird9-Jul-07 13:58

tazbird

9-Jul-07 13:58

I appericate your reply, but I don't ask questions on formums unless I've done my research

Re: Loading sql record into a variable

Luc Pattyn9-Jul-07 14:53

Luc Pattyn

9-Jul-07 14:53

Hi,

I did not intend to offend you, but so many questions seem to be asked because
asking looks simpler than searching...

I am not a database programmer (nor fluent in VB), this is a pattern (in C#) that
I encountered in many articles and discussions (I do read a lot of them):

for a DataSet ds the j-th field in row i can be accessed (read/written) by
ds.Tables["tableName"].Rows[i].ItemArray[j]

I am confident you know how to translate it to VB syntax.

I have never used it, but I do hope this helps. If not, maybe you should
post a new question, this time in the SQL/ADO.NET forum ...

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Loading sql record into a variable

tazbird9-Jul-07 16:02

tazbird

9-Jul-07 16:02

Sorry, I didn't mean to be a jerk either, thanks for your help!

Password Recovery?

shrihit9-Jul-07 10:28

shrihit

9-Jul-07 10:28

Hi,

I am new to this. I need some help with password recovery control. How do we use this?
I tried for some example but did not fine anything. Can some one give a small example how to send password through email?

Shirhit

Re: Password Recovery?

Christian Graus9-Jul-07 15:32

Christian Graus

9-Jul-07 15:32

Which bit are you stuck on ? The .NET framework has classes that make it easy to send email, and you would typically reset the password and send that, but you could get the existing one, if you needed to.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Password Recovery?

Sathesh Sakthivel9-Jul-07 15:45

Sathesh Sakthivel

9-Jul-07 15:45

There is an In-built class password recovery in asp.net2.0 version.

Are you using that one oe you have created your own?

Let all of us know where you have got the Problem so that only we can help you.

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Re: Password Recovery?

shrihit10-Jul-07 3:13

shrihit

10-Jul-07 3:13

I am using the built in Password recovery in asp.net. 1. Do I have to give the database connection in the page load or in the submit button?
2. How do you send an email to the user with new reset password?

How to block the record Delete when canceled?

Richard Jones9-Jul-07 9:14

Richard Jones

9-Jul-07 9:14

I used the drag-a-data-source-to-the-screen method to build a data form.
When I click the X on the navigator toolstrip, it prompts me as in the following code,
but then it deletes the record anyway even if I choose No.
Debugging shows it never does the RemoveCurrent line when I choose No.

Can someone tell me what is happening? Is there an unseen method being called?
I can't find an e.Cancel to use like in other methods.

Private Sub BindingNavigatorDeleteItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorDeleteItem.Click
    Me.Validate()

    If MessageBox.Show("Are you sure you want to delete this employee?", _
        "Employee", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = Windows.Forms.DialogResult.Yes Then
        EmployeeBindingSource.RemoveCurrent()
    End If
End Sub

Paul Watson wrote:
Like, if you say sort of, like, you know, one more, you know, time, I'm going to, like, you know, sort of sort you out, you know.

Re: How to block the record Delete when canceled?

The ANZAC9-Jul-07 12:57

The ANZAC

9-Jul-07 12:57

This might work if it has a handled function:
If MessageBox.Show("Are you sure you want to delete this employee?", _
"Employee", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = Windows.Forms.DialogResult.Yes Then
EmployeeBindingSource.RemoveCurrent()
else
e.handled = true
End If

Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"

Re: How to block the record Delete when canceled?

Richard Jones10-Jul-07 1:48

Richard Jones

10-Jul-07 1:48

Thanks, but no such member exists for System.EventArgs.

Just Empty, Equals, GetHashcode, GetType, ReferenceEquals, and ToString.

I commented out my Remove line, and somewhere it is still being deleted. The table's Deleting and Deleted events are being fired.

The documentation for BindingNavigator states:

BindingNavigator.DeleteItem Property
 When set, this property generates the Click event handler for the Delete button. This event handler calls the RemoveCurrent method when the Delete button is clicked at run time.

Paul Watson wrote:
Like, if you say sort of, like, you know, one more, you know, time, I'm going to, like, you know, sort of sort you out, you know.

Re: How to block the record Delete when canceled?

Richard Jones10-Jul-07 3:13

Richard Jones

10-Jul-07 3:13

After reading my last message, it dawned on me to set the DeleteItem property on the navigator to None.
The button click is still handled by me, so everything is fine now. Smile | :)

Paul Watson wrote:
Like, if you say sort of, like, you know, one more, you know, time, I'm going to, like, you know, sort of sort you out, you know.

Using ContextMenus

Cory Kimble9-Jul-07 6:47

Cory Kimble

9-Jul-07 6:47

I want to bring up the context menu when a choose a record from a listbox. By right clicking on the record but it does not select or highlight the record. How can I do this. I see where I can see a click event but not a rightclick event. If I can't how do I initiate the contextmenu without rightclicking.

Thanks.

Re: Using ContextMenus

Luc Pattyn9-Jul-07 7:15

Luc Pattyn

9-Jul-07 7:15

IIRC there are CP articles on this. Use Search facilities !

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Using ContextMenus

Cory Kimble9-Jul-07 9:31

Cory Kimble

9-Jul-07 9:31

thank you but, I am not finding anything that allows me to select an item in a list by rightclicking on it. do you know what article would have this info? thanks.

Re: Using ContextMenus

Luc Pattyn9-Jul-07 10:03

Luc Pattyn

9-Jul-07 10:03

searching CP for "listbox contextmenu" yields more than 20 hits, including this one[^].

Showing a contextmenu and selecting an item are two different things.

If you need a contextmenu that depends on the item your mouse is hovering above,
that article will do it.

If you want the item to be selected, what is the problem ? determine the item's
index, then call myListBox.SetSelected(index, true);

Hope this helps.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Using ContextMenus

Cory Kimble10-Jul-07 10:19

Cory Kimble

10-Jul-07 10:19

I am trying to select a listbox item using the right click not the left click. At the same time I want the contextmenu to come up so I can use the listbox item with my menu.

Ex: Listbox
Tim Robbins 123 4th street
Bonny Tyler 1888 8th Street.

I want to hover over a record and right click and select(highlight) the record. The context menu will have edit in it. When I click on edit I want all the data from the record that I selected to populate into fields. Can this be done? I see this all the time in Microsoft applications.

Re: Using ContextMenus

Luc Pattyn10-Jul-07 12:30

Luc Pattyn

10-Jul-07 12:30

Hi,

you are right, I just learned there is something different about mouse clicking
for a listbox; it does not behave like other controls such as a panel:

- Click and MouseClick events only work for the left click, not the right click.
and for both MSDN says "This event supports the .NET Framework infrastructure
and is not intended to be used directly from your code."
- MouseDown and MouseUp events do work normally; they offer a MouseEventArgs
with Button property, so that is what should get you started.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Crystal Report, Print Document and Report Viewer

Assaf829-Jul-07 6:46

Assaf82

9-Jul-07 6:46

If some can give me the difference between all this three technology
this will help me very much or if you can guide me from where i can read about the difference between those 3 thechniques.

Thanks a lot

Assaf

Working with MS Word through VBA/MS Access

reegan419-Jul-07 5:49

reegan41

9-Jul-07 5:49

I have made a string variable and have populated it into a Word document (.doc). Now, is it possible to make changes to the text in the word document, then parse that information back into a string variable in the VBA code? (perferably replace the string I used to populate the Word document in the first place) Thanks for your help.

---
reegan41

Last Visit: 31-Dec-99 18:00 Last Update: 10-Jun-24 20:21

Refresh

ᐊ Prev 1...2360 2361 2362 236323642365 2366 2367 2368 2369 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.