|
can anybody send me the code how to insert data into database using my form textbox values.
Aavesh
Aavesh
|
|
|
|
|
What database are you using?
|
|
|
|
|
i'm using mysql please give me the code i'm getting frustrated
thanx
|
|
|
|
|
Do you have a connection already established to your database?
|
|
|
|
|
yes i'm sending u my code in which i have a problem
Dim ConnStr As String = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=AgentImg;uid=root;pwd=;option=3"
Dim con As OdbcConnection = New OdbcConnection(ConnStr)
Dim ad As OdbcDataAdapter = New OdbcDataAdapter()
' Dim str As String = "insert into Category(Category_Name) Values(" + TextBox1.Text + ")"
'Dim str As String = "insert into Category values(@id,@Category_Name,'@Category_Img',@Category_Desc)"
Dim InsCom As OdbcCommand = New OdbcCommand(str, con)
ad.InsertCommand = InsCom
ad.InsertCommand.Parameters.Add(New OdbcParameter("@Category_Name", OdbcType.VarChar, 20))
ad.InsertCommand.Parameters("@Category_Name").Value = TextBox1.Text
ad.InsertCommand.Parameters.Add(New OdbcParameter("@Category_Img", OdbcType.VarChar, 20))
ad.InsertCommand.Parameters("@Category_Img").Value = TextBox2.Text
ad.InsertCommand.Parameters.Add(New OdbcParameter("@Category_Desc", OdbcType.VarChar, 20))
ad.InsertCommand.Parameters("@Category_Desc").Value = TextBox3.Text
con.Open()
ad.InsCom.ExecuteNonQuery()
con.Close()
please i have checked twice field names are correct.
but when i try to store the values .it stores null.
please give me a quick reply.
|
|
|
|
|
I think your problem might be this line.
Dim str As String = "insert into Category(Category_Name) Values(" + TextBox1.Text + ")"
Try changing it to Dim str As String = "insert into Category(Category_Name) Values (" & TextBox1.Text & ")"
Because if its inserting null values then it must be the parameter passing that is wrong.
|
|
|
|
|
And if that doesn't work. Stop using Value = TextBox3.Text. Specify a veriable like Dim txt as String = Textbox3.text. And make sure that it is actually holding a value before you pass it.
|
|
|
|
|
You have two lines where you define an SQL query, but both are commented out. Do you create the variable str anywhere at all?
...and a tip: If you already have code, show that in your initial question, instead of just asking for code.
---
b { font-weight: normal; }
|
|
|
|
|
What is the code to dynamically change the background. So fir instance, if I press a button the background image will change?
Cheers.
|
|
|
|
|
Me.BackgroundImage = Image.FromFile("file name")
example:
Me.BackgroundImage = Image.FromFile("C:\myFile.jpg")
Regards,
Chatura Dilan
If at first you don't succeed, try; try again, so that you know
what not to do the next time. The answer is out there.
|
|
|
|
|
I'm getting an error with the Me.BackgroundImage part. 'BackgroundImage' is not a member of 'WebApplication5.WebForm2'. Do I need to declare anything anywhere?
Cheers.
|
|
|
|
|
Woop s…I mean Window form’s background. You mean Web form’s background. I think I cannot help for that question. Someone will help you or ask your question from ASP.Net forum
Regards,
Chatura Dilan
If at first you don't succeed, try; try again, so that you know
what not to do the next time. The answer is out there.
|
|
|
|
|
This may seems as small question since I am beginner, to Visual Basic
I am developing frontend for accsess data base, there I have several motors which are constant and then I have to add varible for those motors , so I need to have a combo box or list oneside inwhich I can select,then I can add
My question is why when I make combo box or list only one item is showing other dropdown list is not showing..this is the best i can explain it sorry
|
|
|
|
|
can you share your code plz???
|
|
|
|
|
Without seeing your code that sets up and populates the ComboBox, it's impossible to tell you what went wrong.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dear All,
I have developed a VB application and I have created an exe using Visual studio installer but when I try to install it throws an error.
error 1904, Module C:\...msado25.tlb failed to register. HRESULT -2147024769.
how to solve this problem.
plz help me as soon as possible.
Thanks & Regards,
Chandan Kumar
|
|
|
|
|
This is probably because other stuff that the ADO type library depends on is missing.
I take it this is a VB6 app?? Try installing the latest MDAC[^] before installing your app.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi guys,
Anyone know how to display a message in a .vbs?
I want to run a script and display a message to the user depending on the outcome of the script.
Set objWshNetwork = CreateObject("WScript.Network")
strComputer = "k1hq1oa0004a"
Usuario="administrator"
Set objUser = GetObject("WinNT://" & strComputer & "/" & Usuario & ",user")
objUser.SetPassword "123456789"
objUser.SetInfo
''Code to display message here
![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif) 1fm1fu
-- modified at 4:51 Thursday 6th April, 2006
|
|
|
|
|
There's a couple of ways of doing this.
You can use Wscript.Echo "message", where each call to Echo will generate a new message box with just an OK button.
You can call MsgBox (documentation[^]), where you'll have the ability to specify which buttons will show up and also get a return value for which button was clicked.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
How to call Api's in java . This is urgent
|
|
|
|
|
Osama123 wrote: How to call Api's in java
No one will help you, this is not a java forum. Goto
http://forum.java.sun.com/index.jspa[^]
Immediately.
Regards,
Chatura Dilan
If at first you don't succeed, try; try again, so that you know
what not to do the next time. The answer is out there.
|
|
|
|
|
Yikes! The more I think about this, the more blood pours out of my ears!
The other poster is correct. You'd be better off asking this question in a Java forum.
The .NET Framework doesn't expose any methods to call a Java class, but it does expose methods to make calls into just about any Win32 library .DLL as well as any COM-based component.
Here's the trick. You'd have to, IF POSSIBLE (big IF here!), create a COM wrapper around the Java library you wanted to call into. This is where the Java forums come in handy!! Once you have that, you can call the COM wrapper in your VB.NET code, just like any other COM component.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i am writing an application using VB,
i am inserting records using datagrid and i want it not to add duplicate records iam using ado to compare current values with previous one
as this command runs "ado.Recordset.MoveNex" the current record itself get removed why so?
thx
|
|
|
|
|
You should post your code to this forum.
|
|
|
|
|
Hi all,
i having problem to connect my desktop with my mobile phone by bluetooth connection.
Can anyone send mi a simple program to show me how to develop a application which allow desktop with bluetooth dongle to connect and send file to my mobile phone?
Is it using IrDA classes??
Thanks
-- modified at 2:02 Thursday 6th April, 2006
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
