|
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
|
|
|
|
|
Hello there, i have this task to get the source code from a given url. I am sure there is some sort of method in vb.net where you can get that and save it in a memory or text file, however it seems that i am not looking in the right place. If anybody knows, could you please give me some info? Regards
-- modified at 17:18 Saturday 3rd February, 2007
-- modified at 17:21 Saturday 3rd February, 2007
imatureStudent
|
|
|
|