|
hi,
use following code
private sub fillCombo()
sql = "select name from table"
mydataadaptor = New OleDb.OleDbDataAdapter(sql, con)'where con is connection object
mydataset = New DataSet
mydataadaptor.Fill(mydataset)
combo1.datasource=mydataset.table(0)
combo1..DisplayMember = "name"
end sub
one more thing after each insertion or deletion use following statement
combo1.datasource=nothing
call fillCombo
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
it depends how complex you want to go but what if someone else has already edited a name in the table - how do you stop it overwriting the previous change?
Martin
|
|
|
|
|
You don't. Last write always wins.
There are, of course, exceptions to this. But they involve writing a fairly complex data layer that implements "checking out" records for a single client, kind of like checking out books from a library. The client that checks out the records get to modify them. Anyone else gets a readonly copy of the records. This scheme has to be implemented in your data layer. It cannot be implemented soley by the database.
|
|
|
|
|
and therein lies the problem with using all of Net's lovely dataset toys without programming.
I think:
you cant just overwrite business data - you need some kind of -
"This data has changed since you last read it" structure to your data handling.
In the past I have coded this and its a pain - I was hoping that net had come up with an almost drag n drop solution to this issue
thanks (with sincerity to you dave and with sarcasim to microsoft - sigh)
Martin
|
|
|
|
|
It still did not refresh the combobox right.
I thought if we do deletion to the data in the database and call the fillCombo, it will refresh get the new set of data from the database.
All I need to do is just clear the combobox and recall the fillcombo rite?
It didn't work.
|
|
|
|
|
hi,
i dont know what is the mistake. i already check the code . there r no problem.
Please send your code and please write down steps which you follow.
i think there r some minor error in understanding.
Hope u resolve the problem.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
I follow your code exactly.
The strange thing is, if I run it step by step, it will work. The Combobox will refresh correctly. However, when I run it the usual way (F5). It won't refreh correctly. Is there anything to do with the setting of the combobox? I'm using vs.net 2005.
This thing work when I used 2003. But now with 2005, it doesn't work. Is there anything I'm missing?
Thank you
|
|
|
|
|
respected Gurus
i m making a windows application in vb.net.
here i m trying to bind a combobox from dataset.
but whenever i m trying to set the datasource property of my combobox,it jumps to the selectedindexchanged event for the combo box.
my code is as follows:-----------------
code to populate the combobox:---------------
Public Sub populateWebtype()
Try
cnSQL = New SqlConnection(ConnectionString)
Dim strSQL As String = "select webcode,webdesc from webmast"
cnSQL.Open()
cmSQL = New SqlCommand(strSQL, cnSQL)
cmSQL.CommandType = CommandType.Text
adpSQL = New SqlDataAdapter(cmSQL)
ds = New DataSet
adpSQL.Fill(ds)
Dim dr As DataRow
dr = ds.Tables(0).NewRow
'dr(valuemember) = ""
dr("webdesc") = "--Select--"
ds.Tables(0).Rows.InsertAt(dr, 0)
Me.cmbWebType.DataSource = ds.Tables(0).DefaultView 'AFTER THIS LINEJUMPS TO THE SELECTEDINDEXCHANGED
Me.cmbWebType.DisplayMember = "webdesc"
Me.cmbWebType.ValueMember = "webcode"
Me.cmbWebType.SelectedIndex = 0
cnSQL.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
selectedindexchangedevent of combobox:-----------
Private Sub cmbWebType_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbWebType.SelectedIndexChanged
Try
Dim webcode As Integer
webcode = cmbWebType.SelectedValue
strSQL = "select rmdesc as RawMaterial,Micron,Density,Gsm,Quantity as Norm from webnorm,webmast,rmmast where delete_flag <> 'Y' and webnorm.webcode = webmast.webcode and webnorm.rmcode = rmmast.rmcode And webnorm.webcode = " & webcode
cnSQL = New SqlConnection(ConnectionString)
cnSQL.Open()
cmSQL = New SqlCommand(strSQL, cnSQL)
cmSQL.CommandType = CommandType.Text
adpSQL = New SqlDataAdapter(cmSQL)
ds = New DataSet
adpSQL.Fill(ds)
DataGrid1.DataSource = ds.Tables(0).DefaultView
strSQL = "select distinct total_micron,total_gsm,total_quantity,sqmperkg from webnorm where delete_flag <> 'Y'And webnorm.webcode = " & webcode
cmSQL = New SqlCommand(strSQL, cnSQL)
Dim readSQL As SqlDataReader
readSQL = cmSQL.ExecuteReader
While readSQL.Read
If Not IsDBNull(readSQL("total_micron")) Then
txtTotalMicron.Text = readSQL("total_micron")
End If
If Not IsDBNull(readSQL("total_gsm")) Then
txtTotalGsm.Text = readSQL("total_gsm")
End If
If Not IsDBNull(readSQL("total_quantity")) Then
txtTotalQuantity.Text = readSQL("total_quantity")
End If
If Not IsDBNull(readSQL("sqmperkg")) Then
txtSqmPerKg.Text = readSQL("sqmperkg")
End If
End While
cnSQL.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
|
|
|
|
|
Setting the datasource DOES cause an index to become selected. If you don't want that, set a flag and check it in the event.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
thanks sir for ur quick reply
but sir how can i chk so that after setting the datasource it just go to the next statement in the event not to the selectedindexchanged
|
|
|
|
|
Set a class-scope flag (A boolean variable) to true just before you set the datasource of the ComboBox. In the SelectedIndexChanged event, check that flag. It it's set, reset the flag to false and don't do anything in the event handler. If it's false, then you do what you need to accomplish.
|
|
|
|
|
Hi Friend'z...
I need to know all the concepts of working with Strings in VB.Net
can any one help me?
thanks in advance...
|
|
|
|
|
Hi,
of course someone here can help you, but unless you ask a specific question nobody really knows where to start. For the beginning why don't you just read a book about vb.net?
|
|
|
|
|
|
I second the other persons advice, for you to ask such a broad question, indicates you need to read a book.
However, intellisense is also a great teacher, create a string, like
dim s as string = "I am still learning"
then type s. and all the methods of the string class will come up. You can also refer to the MSDN site ( msdn.microsoft.com ) for online documentation.
If you're concatenating lots of strings, use a stringbuilder, and if you need to do complex searching in strings, use regular expressions.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
i am usind VB.NET 2003 i want to get the data from dataset to excel sheet.How to do it.Please help me out.urgent
Mohinder Singh
|
|
|
|
|
|
can anyone explain clearly whether VB.net is platform independent or not? so many people saying their own style. still i am confused. TIA
|
|
|
|
|
I think java is platform independent .It can run on both windows as well as linux platform.unlike .net platform which runs only on windows.
|
|
|
|
|
Not true. .NET runs under Linux, using Mono. The difference is that there's a lot more Java VMs than there are .NET implimentations.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
Thank You Sir
What are mono?
and one more thing
so is it right to say that .net is platform independent?
|
|
|
|
|
Nilish wrote: What are mono?
One of those things that google knows all about.
Nilish wrote: so is it right to say that .net is platform independent?
Sort of. Like the OP said, it's hard to get a straight answer, because the answer is, anyone can write a .NET engine for any platform, but right now, the Mono people are doing it for Linux, and that's about it. I don't know how complete Mono is, but I think it's close to a complete .NET 1.1 implimentation.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
From what I can see from a look on their roadmap, everything (?) is up to 1.1, and most of 2.0 is implemented in most of the parts.
Anyhow, unless you have some very specific needs, it should be fully usable.
---
single minded; short sighted; long gone;
|
|
|
|
|
Please don't crosspost.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
I would say at this point .NET is not platform independant, but has the protential of being so.
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|