|
i have declare the str variable in the local module that is in button
click(). i'm storing the sql query in the str variable.
|
|
|
|
|
Where do you set the value of str1, then, that you are using in the command object? Please show all relevant code.
---
b { font-weight: normal; }
|
|
|
|
|
Imports System.Data
Imports System.Data.Odbc
Partial Class Category
Inherits System.Web.UI.Page
Public x As Integer
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
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 InsCom As OdbcCommand = New OdbcCommand(str, con)
'con.Open()
'Dim str As String = "insert into Category(Name,address,age,city) values('"&Name&"','"&Address&"','"&Age&"','"&City&"')"
'sqlCmd.CommandText = str
'sqlCmd.CommandType = CommandType.Text
'sqlCmd.Connection = con
'sqlCmd.ExecuteNonQuery()
Dim str1 As String
Dim ad As OdbcDataAdapter = New OdbcDataAdapter()
str1 = "insert into Category(id,Category_Name,Category_Price,Category_Img,Category_Desc,Category_header) Values('','" & TextBox1.Text & "', '" & TextBox2.Text & "','" & FileUpload1.FileName & "','" & TextBox4.Text & "','" & TextBox5.Text & "' )"
'If (Option1.Items(1).Value = 1) Then
'str = "insert into Category(id,Category_Name,Category_Price,Category_Img,Category_Desc,Category_header) Values('','" & TextBox1.Text & "', '" & TextBox2.Text & "','" & FileUpload1.FileName & "','" & TextBox4.Text & "','" & TextBox5.Text & "' )"
'Else
'str = "insert into Category(id,Category_Name,Category_Price,Category_Img,Category_Desc,Category_header) Values('','" & TextBox1.Text & "', '' ,'" & FileUpload1.FileName & "','" & TextBox4.Text & "','" & TextBox5.Text & "' )"
' End If
'If (Option1.Items(1).Selected = True) Then
'Dim str As String = "insert into Category values('',@Category_Name,'',@Category_Desc)"
Dim InsCom As OdbcCommand = New OdbcCommand(str1, con)
If Not FileUpload1.PostedFile Is Nothing And FileUpload1.PostedFile.ContentLength > 0 Then
Dim fn As String = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName)
Dim SaveLocation As String = Server.MapPath("images") & "\" & fn
Try
FileUpload1.PostedFile.SaveAs(SaveLocation)
Catch Exc As Exception
'Response.Write("Error: " & Exc.Message)
End Try
Else
Response.Write("Please select a file to upload.")
End If
'Dim str As String = "insert into names values(@Name,@Addres,@Age,@City)"
'Dim str As String = "insert into Category(@id,@Category_Name,@Category_Img,@Category_Desc)"
'con.Open()
con.Open()
InsCom.ExecuteNonQuery()
'ExecuteNonQuery()
'MsgBox("insert into Category values('2',@Category_Name,'',@Category_Desc)")
'InsCom.ExecuteReader()
' GridView1.DataSource = InsCom.ExecuteReader()
'GridView1.DataBind()
TextBox1.Text = ""
TextBox2.Text = ""
TextBox4.Text = ""
TextBox5.Text = ""
con.Close()
End Sub
Protected Sub RadioButtonList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Option1.SelectedIndexChanged
If (Option1.Items(0).Selected = True) Then
' x = 1
TextBox2.Enabled = True
End If
If (Option1.Items(1).Selected = True) Then
x = 2
TextBox2.Enabled = False
End If
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If (Page.IsPostBack = False) Then
x = 1
End If
End Sub
End Class
|
|
|
|
|
That's better, now the code looks like it's possible to run.
The code in the event seems to be correct. Do the records that are added in the database contain the same information, or is the second record mostly empty? The later would suggest that the event is executed twice.
Write something to the page from the event, so that you see if it is called twice.
---
b { font-weight: normal; }
|
|
|
|
|
I want to display the data in datagrid and using sqlconnection with ado.
What is the code for that.
and is there any difference b/w datagrid and Flex data grid control
|
|
|
|
|
1.make sqladapter object.
2.pass the connstr,on in it.
3.set the datasource property of datagrid.
4.bind the datagrid
|
|
|
|
|
What are the commonly asked questions in the interviews in vb.net for the fresher.
|
|
|
|
|
Not a comprehensive list, but a start.
You really should look at some employment agencies in your country too. Get to know the recruitment people and they can provide some assistance.
1. How many years experience do you have?
2. What is your highest academic qualification?
3. What is the difference between a Class and a Module?
4. Do you play football/soccer/cricket/paintball/drive go-karts/etc...?
5. Why should you not use global variables?
6. When, if ever, should you force the garbage collection to run?
7. In OO terminology, what does 'encapsulation' mean?
8. How would you test a new assembly?
9. If you have a programming question, where would you look for help and in which order...
a. Visual Studio Help
b. MSDN website
c. Google search
d. Your workmates
e. The Code Project
f. all of the above in that order
10. Do you comment all your code? (Honestly?)
11. Why should you be considered for this job? (i.e. what benefit can you bring to the company)
However, the most important one I ask potential candidates is:
12. Are you a TEAM PLAYER?
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
|
|
|
|
|
Steve Pullan wrote: 12. Are you a TEAM PLAYER?
Oooohhhhh, I LOVE this one. In my experience, this means "Will you accept everything we say as gospel and not question anything we tell you or do to you?" Even way past the point where they cut your paycheck for doing outstanding work and give themselves raises afterward.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi Dave, yep I agree that's the way it could work - I have fallen foul of this too in the past, but I'm approaching it purely from a devloper's perspective (I'm not a manager) where pro-active teamwork is highly valued.
Among other things I've had guys metaphorically lock themselves in a closet and never interact with the rest of the team. When code review time comes along they take every fault found as a personal insult and invariably we find that their code has also diverged from the project scope considerably.
My philosophy is that it is not my code nor your code - all code is our code. (ego-less programming, the reference escapes me ATM) That way we all reap the rewards of our efforts.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
hi all, i'm doing my project in VB.NET using SQL server as backend. I need a code to do the following
1. i got a form where in user types his userid
2. based upon the userid, the crystal report should have fields containing info abt that particular user (the details which already stored in DB)
Please Help me.....
|
|
|
|
|
can anyone show me how to update a access database using vb .net?
to be more clear, i have an access database call "databasename.mdb",and the table is named "prduct" when the user select from the combobox matching column1, column2's value will show in the textbox ready to be modify, when seavebutton click the text in textbox will update to column2.
i know how to do connect and read from the database only updating need help! thanks for your time!
|
|
|
|
|
You can use
Me.yourTableAdapter.Update(Me.yourDataBaseDataSet.yourTable)
Just as you load data
Me.yourTableAdapter.Fill(Me.yourDataBaseDataSet.yourTable)
and check whether you have created the primary key
Regards,
Chatura Dilan
|
|
|
|
|
do you mean this?
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=""c:\databasename.mdb"";"
Dim objConn As New OleDb.OleDbConnection(connectionString)
objConn.Open()
Dim ds As New DataSet
Dim da2 As OleDb.OleDbDataAdapter
Dim sql As String
sql = "SELECT [Name] FROM Developer"
da2 = New OleDb.OleDbDataAdapter(sql, objConn)
da2.Fill(ds, "Developer")
Dim cb As New OleDb.OleDbCommandBuilder(da2)
ds.Tables("Developer").Rows(0).Item(0) = "yes"
da2.Update(ds, "Developer")
but it give me an "Invalid Operation Exception" ---"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."
can anyone tell me why?
p.s. do i have to created the primary key? why do i have to check?
|
|
|
|
|
|
Can you have 1.1 and visual studio 2003 and 2.0 and visual studio 2005 on one machine without everything going wonky?
|
|
|
|
|
Yes. Visual Studio 2003 and 2005 can coexist on the same machine.
|
|
|
|
|
Please do not corss-post!
--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
i have a problem with vb.net 2005.
when set localization = true on a form and add databinding to textbox.text and write on load_form event
fill(dataset) i can see my data )( my database has data)
and when change the property localization = false
i can see my data
some body help me
.....
123
|
|
|
|
|
What don't you know?
Chatura Dilan
-- modified at 23:45 Monday 10th April, 2006
|
|
|
|
|
What do you expect to happen?
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
this massege show after day or two day on more for customers
this massege is :-
(null) not a valid win32 application
then program not open
please send me solution it
Ahmed
|
|
|
|
|
It's virtually impossible for anyone to provide an answer based on this, unless that's the message you get when .NET 2.0 is not installed on the target machine.
Does your app do any sort of error logging ? Perhaps you should add some.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
|
pls i need the help immediately pls help me to generate the source code for direct exchange of data between xml and relational database by using mapping rules in xml.very urgent pls
aiyshu
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
