Dim cn AsNew SqlConnection("myConnectionStringHere")
Dim cmd AsNew SqlCommand()
.Connection = cn
.CommandType = CommandType.Text
.CommandTExt = "your SELECT query here"
Dim dt AsNew DataTable("PlazimorphGenes")
Dim da AsNew SqlDataAdapter(cmd)
plazimorphGenesDataGrid.DataSource = dt
you can then look after the delete query yourself too
Dim dr as DataRow = tRow(0)
Dim queryString asString = "DELETE PlazimorphGenes WHERE Id = @Id"' Correct synatax escapes me
Dim cn AsNew SqlConnection("yourConectionString")
Dim cmd AsNew SqlCommand
.Connection = cn
.CommandType = CommandType.Text
.CommandText = queryString
I don't speak Idiot - please talk slowly and clearly
Thank you for the link! Yes, I've used the data wizard. It's been a few years working on such a big database project as a 'hobby project'. Most of the tutorials and examples use it.
I've been able to create a DELETE function on the tables and its working, also a INSERT on.
The next step I've having issue with is filling a combo box with a query. I've added the query to the table but can't get it/figure our how to apply it to filtering data to the combo box. I also tried using the 'Filter' on the Binding source but it doesn't seem to work.
i want to learn more about VB & how i can make a program that will allow me to Add Quotations make calulation from user inputs, Cross-ref this information agaisnt a M$ database, then export a quotation into a pdf, and also export data into M$ Database to create new jobs, and finally i would like to create a Order acknowledgement from all the information to send to customers & export into Sage.
im hoping there is a magical book that can teach me all these steps
and hoping i can buy it from amazon
and hoping you guys and gals may know the perfect book!
we have been using a system at work at for many years now, which i did create but it is very disjointed, quotations = made in Excel manual input and searchs Job = created in Access manual input from quotations Order acknowledgements = made in sage - another manual repeated job.
overal a job is re-entered 3 to 4 time repeated. when new & 2 times when existing and its a re-order.
Books aren't written to accommodate ones business-requirements. There are a bunch of video's and how-to's on MSDN, that'd might be a useful introduction into the specific topics you request. I'd recommend "Head on C#", but it's not about VB and not about Access.
I am a VB.Net programmmer. I use the SQL Server and as backend but when I deploy my application to another computer, It is required the SQL Server must be installed on another computer. Please suggest how to work with SQL database (.mdf,.ldf) without installing SQL Server on another computer becuase I cannot go everywhere for each computer to install the application If user of my application is just simple user. If there is another solution, please let me know. I will be very thankful to him/her.
But please remember that VB6 is a depreciated product and not alot of people will support it.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
How to read the complex type data from WSDL in vb.net? I am using below code for same.I am getting 'Warning 1 Variable 'ct_BundleBalanceDetails' is passed by reference before it has been assigned a value. A null reference exception could result at runtime.' message. Please help me. '
ProtectedSub Page_Load(ByVal sender AsObject, ByVal e As System.EventArgs) HandlesMe.Load
TryDim wbService AsNew WEB_APIs.Service
Dim ct_BundleBalanceDetails As WEB_APIs_SCBF.BundleBalanceDetailsComplexType()
Response.Write("Calling BundleBalanceRequest <br>")
Dim ResponseCode AsString = wbService.BundleBalanceRequest(WEB_APIs_SCBF.InterfaceSimpleType.WEB, "03189719", ct_BundleBalanceDetails)
Response.Write("<br> BundleBalanceResponse ")
Catch ex As Exception
Response.Write("<br> API call is failed <BR>" & ex.Message)
If the BundleBalanceRequest just sets the ByRef parameter, you can either ignore the warning or set the variable to Nothing.
Dim ct_BundleBalanceDetails As WEB_APIs_SCBF.BundleBalanceDetailsComplexType() = Nothing
I think computer viruses should count as life. I think it says something about human nature that the only form of life we have created so far is purely destructive. We've created life in our own image. Stephen Hawking
Thanks for reply.I am facing below mentioned error. Please help me.
<!-- Start of BundleBalance API --><!-- soap:Body of BundleBalanceRequest message --><xs:elementname="BundleBalanceRequest"><xs:complexType><xs:sequence><xs:elementname="Interface"type="tns:InterfaceSimpleType"/><xs:elementname="MSISDN"type="xs:string"/></xs:sequence></xs:complexType></xs:element><!-- soap:Body of BundleBalanceResponse message --><xs:elementname="BundleBalanceResponse"><xs:complexType><xs:sequence><xs:elementname="ResponseCode"type="xs:integer"/><xs:elementname="ResponseData"><xs:complexType><xs:sequence><xs:elementname="BundleBalanceDetails"type="tns:BundleBalanceDetailsComplexType"minOccurs="0"maxOccurs="unbounded"/></xs:sequence></xs:complexType></xs:element></xs:sequence></xs:complexType></xs:element>
Dim wbService As New WEB_APIs_SCBF.Service Dim ct_BundleBalanceDetails As WEB_APIs_SCBF.BundleBalanceResponseResponseData
Response.Write("Calling BundleBalanceRequest ")
Dim ResponseCode As String = wbService.BundleBalanceRequest(WEB_APIs_SCBF.InterfaceSimpleType.WEB, "03189719", ct_BundleBalanceDetails)