Update Data To Database Using Table Adapter - Visual Basic Discussion Boards

thepityone13-Feb-06 20:44

13-Feb-06 20:44

hello again

can you please help me again about this datagridview coz i'm not so familiar about this control....my question is ...if i'm going to add new record from the datagridview how can i clear again the datagridview to able for me to add again new record without deleting the current record...looks like this...first i'm going add record in the datagrid so its already there then second i want to add new record agin but i want the datagridview to cleared before the second record in.. without deleting the current record...how can i do that...can you help please...

thanks in advance

how can i add unbound data to datagridview

thepityone13-Feb-06 20:25

thepityone

13-Feb-06 20:25

hi

i have a problem of populating the datagridview which is unbound data coming from the other form....look like this...i well explain...i used two forms one form who holds the datagridview and the second forms holds the textboxes which i'm going to input my data and well putted into the others form which has the datagrid...i'm stock in this case...i'm not using binding,,all i want to know is..how do i get the data from the other form...
can you please help to formulate the code for unbound...please guys...

thanks

Re: how can i add unbound data to datagridview

Dave Kreskowiak14-Feb-06 8:50

Dave Kreskowiak

14-Feb-06 8:50

Working with Multiple Forms in Visual Basic .NET: Upgrading to .NET[^] shows you how to pass data between forms.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

on mouse event

aqui_i13-Feb-06 20:07

aqui_i

13-Feb-06 20:07

Hi... Right now I'm using visual basic in access so the controls are limited. there is no timer included in the controls that i'm using. i need to stop a process when i press escape key... so i used doevents and on_keypress. But the problem is while the process is running you can press the buttons in the form... the quit button etc. including the process button. if i disable the process button after i pressed it there would be an error and it will not continue the process. is there a way that i can disable the mouse event? tnx

Re: on mouse event

Dave Kreskowiak14-Feb-06 8:48

Dave Kreskowiak

14-Feb-06 8:48

Access is a funny animal... IIRC, you cannot disable a button that has the input focus. You have to give another control the focus before you can set your button's Enabled property to False.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Chang Properties File Summary

kbbman13-Feb-06 20:01

kbbman

13-Feb-06 20:01

help me... Cry | :((

I want change properties of file as summary tab (title,subject,author)
by use vb.net

kbbman2

Re: Chang Properties File Summary

Dave Kreskowiak14-Feb-06 8:46

Dave Kreskowiak

14-Feb-06 8:46

It's most definately NOT easy! Here[^] is a sample of the code you need to pull this off. There is no native support for this in the .NET Framework BCL.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Update Data To Database Using Table Adapter

shiroamachi13-Feb-06 19:32

shiroamachi

13-Feb-06 19:32

Hi,

I'm using the following code to update my database but the changes in my data table never reflected back to my database

<br />
<br />
Dim aDataTable as new aDataSet.MyTable<br />
Dim aTableAdapter as new aDataSetTableAdapters.MyTableTableAdapter<br />
<br />
aTableAdapter.Fill ( aDataTable )<br />
<br />
Dim aRow as DataRow<br />
<br />
aRow = aDataTable.NewRow()<br />
aRow.item(0) = "Test 123"<br />
<br />
aDataTable.Rows.Add ( aRow )<br />
<br />
aDataTable.AcceptChanges()<br />
aTableAdapter.Update( aDataTable )<br />
<br />

What have I miss ?
Thank you

WiL

Re: Update Data To Database Using Table Adapter

Dave Kreskowiak14-Feb-06 8:40

Dave Kreskowiak

14-Feb-06 8:40

You're calling the .AcceptChanges() method to commit the changes to the DataSet, not the database. Call the DataAdpter's .Update() method BEFORE you call AcceptChanges

Update commits any changes back to the database.

AcceptChanges commits any changes to the DataTable and resets each DataRow's status to Unchanged. This is why no changes are being written back to the database. Because you've told the table there are no changes!

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Update Data To Database Using Table Adapter

shiroamachi14-Feb-06 16:38

shiroamachi

14-Feb-06 16:38

You're the best!
Thanks alot Wink | ;)

WiL

picture comparison

maytel13-Feb-06 16:42

maytel

13-Feb-06 16:42

is there another way of comparing duplicate picture (jpg)
aside from filename, filesize and dates

tnx in advance

Re: picture comparison

Stephen Hewitt13-Feb-06 19:28

Stephen Hewitt

13-Feb-06 19:28

You could try doing a SHA1 hash on it. There's C++ code that does it on CP but I'm not sure about VB/VB.NET.

Steve

Compare two files

MeterMan13-Feb-06 15:11

MeterMan

13-Feb-06 15:11

Could someone please explain to me the easiest way in code to compare two files?

I have created an openfiledialog to select 2 files and would like to compare them. I looked at msn but got very confused. If you don't mind taking the time to show me an example that would be wonderful.

Thanks again.
Confused | :confused:

Win32newb
"If I wrote a book like I code. It would be one page thick and contain only one word (DUH!)"

Re: Compare two files

Joshua Quick13-Feb-06 15:18

Joshua Quick

13-Feb-06 15:18

What you're making is a Diff utility.

There are a couple articles on this website explaining how to do this. See the links below.
http://www.codeproject.com/vb/net/DiffQuest.asp[^]
http://www.codeproject.com/csharp/differ.asp[^]

-- modified at 23:16 Monday 13th February, 2006

need help urgently - implementation of edge detection

preci13-Feb-06 14:58

preci

13-Feb-06 14:58

hello everyone!! I am a student from India. I need the source code for implemention of sobel and canny edge detection for tumour image analysis.If anyone knows where I can get it or has the source code please please notify. Cry | :((

signing off is preci

Re: need help urgently - implementation of edge detection

Joshua Quick13-Feb-06 15:13

Joshua Quick

13-Feb-06 15:13

There is a .NET article on edge detection on this website. See the below link.
It's in C#. So, you'll either need to convert the parts you need into VB.NET or setup a C# library for your VB app to use.

http://www.codeproject.com/cs/media/edge_detection.asp[^]

Extra space added to a records data fields

Jlawrnce13-Feb-06 11:03

Jlawrnce

13-Feb-06 11:03

I'm getting a extra space added to a records fields when I update the record. This is a VB6 Access DB application.
The only thing I can think of is the SQL

<br />
strSQLEditCustomer = "UPDATE Customers SET ContactFirstName = ' " & txtFName.Text & " ' , ContactLastName = ' " & txtLName.Text & " ' , BillingAddress = ' " & txtAddress.Text & " ' , City = ' " & txtCity.Text & " ' , State =  ' " & CboState.Text & " ' , PostalCode =  ' " & CboZip.Text & " ' , PhoneNumber= ' " & txtPhone.Text & " ' , EmailAddress = ' " & txtEmailAddress.Text & " ' WHERE CustomerID = " & SearchCustID & " "<br />

Re: Extra space added to a records data fields

Jlawrnce13-Feb-06 12:32

Jlawrnce

13-Feb-06 12:32

I figured it out. FYI for those who may come across the same problem

in the SQL when filling a table field and your setting it = to a textbox, the ' " & textbox1.text & " ' will result in the space added to the beginning of the field. changing the SQL to '" & textbox1.Text & "' will fix the problem. Note the difference in the placement of the single quotes between the 2 examples.

Re: Extra space added to a records data fields

Dave Kreskowiak13-Feb-06 17:21

Dave Kreskowiak

13-Feb-06 17:21

You wouldn't have to worry about this problem at all if you used parameterized queries.

SQL Injection Attacks and Some Tips on How to Prevent Them[^]

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Extra space added to a records data fields

Pankaj Kulkarni14-Feb-06 0:59

Pankaj Kulkarni

14-Feb-06 0:59

Hi,

Jlawrnce wrote:
strSQLEditCustomer = "UPDATE Customers SET ContactFirstName = ' " & txtFName.Text & " ' , ContactLastName = ' " & txtLName.Text & " ' , BillingAddress = ' " & txtAddress.Text & " ' , City = ' " & txtCity.Text & " ' , State = ' " & CboState.Text & " ' , PostalCode = ' " & CboZip.Text & " ' , PhoneNumber= ' " & txtPhone.Text & " ' , EmailAddress = ' " & txtEmailAddress.Text & " ' WHERE CustomerID = " & SearchCustID & " "

Use "Trim" method to supress the extra space
from the controls
like
"UPDATE Customers SET ContactFirstName = '"& Trim(txtFName.Text) &"'"

This will also help you.

Pankaj Kulkarni

Navigation Panel

ssfargade13-Feb-06 10:25

ssfargade

13-Feb-06 10:25

Hi,

How to create Navigation Panel similar to the navigation panel seen in Microsoft® Outlook 2003, in vb.net.

waiting your answer.

Re: Navigation Panel

Joshua Quick13-Feb-06 11:26

Joshua Quick

13-Feb-06 11:26

You'll either have to...

1) Search the Internet for a free control which does this. Cross your fingers. Maybe this will do it for you?
http://www.codeproject.com/useritems/fireballwindowsforms.asp[^]

2) Buy a control that already does this, like the one in the below link.
http://www.devcomponents.com/dotnetbar/NavigationBar.html[^]

3) Build your own user control that does this. This requires some skill.

Re: Navigation Panel

Mekong River13-Feb-06 14:46

Mekong River

13-Feb-06 14:46

Joshua Quick wrote:
3) Build your own user control that does this. This requires some skill.

http://www.microsoft.com/MSPress/books/5203.asp[^]

convert date to string

ssfargade13-Feb-06 10:17

ssfargade

13-Feb-06 10:17

Hello everybody,

how can convert date (in numbers) into the text format(string) in vb.net.

thank n take care.

bye...

Re: convert date to string

Joshua Quick13-Feb-06 11:17

Joshua Quick

13-Feb-06 11:17

You need to use the Date[^] type.

Dim myDate As New Date(myYear, myMonth, myDay)<br />
Dim myString As String = myDate.ToShortDateString()

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