|
http://www.codeproject.com/cs/database/gridex.asp[^] looks helpful. You could either use the control, or look through the code to see how it works.
Depending on your datasource, you may be able to run SQL on the source, or you can iterate over the Rows collection to find the values you need.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
hi thanx for the link...i had a look it seems to be done in C. I have done it in vb code. i used the wizard to create the forms. Using a untyped dataset i think. all the search code ive found is for typed datasets i think...
Me.objdsDiary.Clear()
Me.OleDbDataAdapter1.SelectCommand.CommandText = "Select * from 0830 where AppointmentDate like '%" & Trim(Me.lbl2.Text) & "%'"
Me.OleDbDataAdapter1.Fill(Me.objdsDiary)
or
Adodc1.RecordSource = "Select * from secretary where club = """ & txtSearch.Text & """"
Adodc1.Refresh
or
Private Sub Command1_Click()
With Adodc1
.Recordset.Find "Au_Id=" & CInt(txtAuthorId.Text)
End With
End Sub
which do not work as i dont have adodc, all i have is CottageBookingSystemDataSet, TblEmployeeBindingSource, TblEmployeeTableAdapter, TblEmployeeBindingNavigator.
Ive been looking on so many forums.
|
|
|
|
|
i have found the code to search using a string,
TblCustomerBindingSource.Filter = "txtFirstName LIKE '%" & TextBox1.Text & "%'"
how to i implement it to search a int eg the primary key for customerid?
|
|
|
|
|
I have used Testfile connection with my application, but i don't know how to use sql statement.
Thanks
................
|
|
|
|
|
You don't know how SQL works ? It's pretty simple, and there are tons of examples on the web. At it's most basic level, select * from [tablename] will return all the data in a table, and select 8 from [tablename] where [column] = [value] ( with single quotes around strings ) will select a particular value.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
What is [tablename] i don't understand wheter i used text file.?
................
|
|
|
|
|
OK, you're connecting to a text file ? What does that have to do with SQL ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I don't know how to use SQL statment and fill data to dataset
Thanks
................
|
|
|
|
|
From a textfile ? Is that even possible ? Your textfile doesn't have any named columns, if some sort of reading of textfiles is possible, I doubt it's using SQL.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
hello
how can i delete subfolders within a folder
----
Regards
Ramy
|
|
|
|
|
The same way you delete a folder, one at a time. YOu need to iterate over sub files and folders before you can delete a folder.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
|
test to my mail
Regards
Ramy
|
|
|
|
|
How can i Unzip the zip files using vb.net code...
Feroze
|
|
|
|
|
I think VB2005 has a zip library, any other version, you need an external library
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
|
if u have installed winzip on ur machine and if it allows u zip/unzip at command prompt then u can do it easily....
1) create a process by specifing executable path of winzip.exe...
2) specify other parameters i.e. files to zip/unzip with required switches...
3) run this process...
Thanks & Regards...
Amit
|
|
|
|
|
Hello everybody!
This may sound like a really stupid question, but let me tell you that i'm new to .Net, so please be patient with me!
I need to find out what is the equivalent of the .additem function from VB in .Net.
Thank you sooo much!
|
|
|
|
|
That depends, what does it do ? Is it a method on a control ? If so, the controls have Items collections, so it becomes Items.Add.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi guys this is probably a really stupid question, but is there a better way of testing if an object implements an interface then this:
Try
CType(f, ISomeInterface)
Return True
Catch ex As Exception
Return False
End Try
Pablo
while(1){DoTheDo();}
|
|
|
|
|
I believe VB has syntax for the 'is' keyword, in C# it's if f is ISomeInterface. Also, you can compare f.GetType() and typeof(ISomeInterface).
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thanks, it seems you are the one to give me the answers most of the time LOL. Glad to have you here 
Pablo
while(1){DoTheDo();}
|
|
|
|
|
Actually that didn't quite work...but it did give me another idea that works:
If Not f.GetType.GetInterface("ISomeInterface") Is Nothing
thanks 
Pablo
while(1){DoTheDo();}
|
|
|
|
|
The proper syntax for using the GetType method is:
if(f.GetType()==typeof(IOtherType))
return true
else
return false
Visual Basic should not be much different from this.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios[ ^]
|
|
|
|
|
i have created a datagrid using the vb.net wizard for my customer form, where you can add delete and navigate through records.
i have been searching the internet to find a way i can search a record in the customer table by the given primary key which is idsCustomerId. I am a complete beginner. Does anyone have any sample code?
This is what is generated by the wizard that i can see.
Public Class frmCustomer
Private Sub TblCustomerBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblCustomerBindingNavigatorSaveItem.Click
Me.Validate()
Me.TblCustomerBindingSource.EndEdit()
Me.TblCustomerTableAdapter.Update(Me.CottageBookingSystemDataSet.tblCustomer)
End Sub
Private Sub frmCustomer_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CottageBookingSystemDataSet.tblBooking' table. You can move, or remove it, as needed.
Me.TblBookingTableAdapter.Fill(Me.CottageBookingSystemDataSet.tblBooking)
'TODO: This line of code loads data into the 'CottageBookingSystemDataSet.tblCustomer' table. You can move, or remove it, as needed.
Me.TblCustomerTableAdapter.Fill(Me.CottageBookingSystemDataSet.tblCustomer)
End Sub
Private Sub ToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click
End Sub
Private Sub ComboBox1_SelectedValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedValueChanged
Me.TblCustomerBindingSource.Position = Me.ComboBox1.SelectedIndex
End Sub
End Class
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
