|
I was attempting to use the sample code above like this:
Dim tRow As PlazimorphDBDataSet.PlazimorphGenesRow
Dim genename As String
genename = MTBGeneLabel.Text.ToString()
tRow = Me.PlazimorphGenesTA.FillByGene(Me.PlazimorphDBDataSet.PlazimorphGenes, genename)
tRow.Delete()
Me.PlazimorphGenesTA.Update(Me.PlazimorphDBDataSet.PlazimorphGenes)
I did go into the database designer and create the specific query on the table. It looks SELECT code section you posted above.
The error I'm getting is specific to this line:
tRow = Me.PlazimorphGenesTA.FillByGene(Me.PlazimorphDBDataSet.PlazimorphGenes, genename)
I'm getting
"Value of type 'Integer' cannot be converted to 'PlazimorphAdmin.PlazimorphDBDataSet.PlazimorphGenesRow'"
I thought Visual Studio would automatically add the stored procedure. Maybe I need to add it as you suggest.
If I change the line to this:
tRow = Me.PlazimorphGenesTA.FillByGene(genename)
I get the following two errors:
"Argument not specified for parameter 'genename' of 'Public Overrideable Overloads Function FillByGene(dataTable as PlazimorphDBDataSet.PlazimorphGenesDataTable, genename as String) As Integer'."
and
"Value of type 'String' cannot be converted to 'PlazimorphAdmin.PlazimorphDBDataSet.PlazimorphGenesDataTable'."
And If I use this version:
tRow = Me.PlazimorphGenesTA.FillByGene(tPlazimorphGenes, genename)
I get
"Value of type 'Integer' cannot be converted to 'PlazimorphAdmin.PlazimorphDBDataSet.PlazimorphGenesRow'"
The query I have attached to the table is this:
SELECT Gene, FindMethod, TDiscovery, TReplicate, AA_A, AA_T, AA_G, AA_C, ImageFileName, Description, SpxReplicationItem, IconFileName, Complete, Image, Icon, Type,
UniqueID, Chromosome, Rarity, ParentGene, Name
FROM PlazimorphGenes
WHERE (Gene = @genename)
I have a solid background in visual basic programming but haven't work this much with a database.
|
|
|
|
|
OK, are you generating the DataSet from the Visual Studio Wizard?
This exposes you to the evils of the BindingSource, TableAdapter, and TableAdapterManager classes. (I and many others here avoid them like the plague).
This may be a usefull article: A Detailed Data Binding Tutorial (CP)[^]
Rolling your own database access is not so hard:
...
Dim cn As New SqlConnection("myConnectionStringHere")
Dim cmd As New SqlCommand()
Try
cn.Open()
With cmd
.Connection = cn
.CommandType = CommandType.Text
.CommandTExt = "your SELECT query here"
.Parameters.AddWithValue("@genename", yourGeneNameVariable)
Dim dt As New DataTable("PlazimorphGenes")
Dim da As New SqlDataAdapter(cmd)
da.Fill(dt)
plazimorphGenesDataGrid.DataSource = dt
End With
...
you can then look after the delete query yourself too
...
Dim dr as DataRow = tRow(0)
Dim queryString as String = "DELETE PlazimorphGenes WHERE Id = @Id"
Dim cn As New SqlConnection("yourConectionString")
Dim cmd As New SqlCommand
Try
cn.Open()
With cmd
.Connection = cn
.CommandType = CommandType.Text
.CommandText = queryString
.Parameters.AddWithValue("@Id", CInt(dr("Id")))
.ExecuteNonQuery()
End With
UpdateDataGrid(...)
I don't speak Idiot - please talk slowly and clearly
"I have sexdaily. I mean dyslexia. Fcuk!"
Driven to the arms of Heineken by the wife
|
|
|
|
|
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.
|
|
|
|
|
hi
Wanted with VB.Net Last Date modified Registry key
To do this I need to use the RegQueryInfoKey API
|
|
|
|
|
alirezamansoori wrote: I need to use the RegQueryInfoKey API
Very true; you also need to use the documentation[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
RegistryKey Class does not have the ability to do my job
|
|
|
|
|
Then you probably need to use P/Invoke[^] to get access to the Win32 function.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Hi,
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.
so im hoping i can strimeline all this down
|
|
|
|
|
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.
|
|
|
|
|
Hi!
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.
|
|
|
|
|
How is the application going to be installed? Perhaps you can include it there
|
|
|
|
|
hi
how writen code in vb for 8queen genetic algoritm
please send for me source code
|
|
|
|
|
This is not the kind of site which will just give you an answer to your homework.
You must prove that you have made an attempt to solve a problem and the folks here will be happy to help you.
|
|
|
|
|
See here[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
for this system do i need DAQ hardware?
TQVM
WISEL UTeM
modified 21-Nov-12 9:29am.
|
|
|
|
|
So you've slept through your entire course, not learnt anything, and now you expect someone else to write your final year project for you?
That's not going to happen. 
I suggest you go and talk to your tutor to find out what your options are.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
tq for ur word.
i haven't learn about visual basic for this 5 years.
i only learnt computer hardware.
|
|
|
|
|
Friends
Please inform me how can we control the monitor brightness
in visualbasic 6.0
Thanks and regards,
Muhammed Niyas
|
|
|
|
|
A quick check on Google shows this article.
http://www.vbforums.com/showthread.php?561682-2008-How-to-adjust-screen-brightness[^]
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
|
|
|
|
|
I need code for Export data from Gridview to Sql Server in vb.net windows application
|
|
|
|
|
..this ain't MacDonalds, so you can't "order" code like you would do with a hamburger.
The grid is called a DataGridView, not a "gridview". There are quite some examples and tutorials on manipulating data using VB.NET; what did you try?
We don't deliver ready-made solutions here, if you have a specific question we can help.
|
|
|
|
|
Gridview is in the webdev for Visual Studio... I'll bet there's a good chance he picked that because of the work "web", without understanding the differences.
That said, now you've made me hungry for a burger. 
|
|
|
|
|
Bert Mitton wrote: That said, now you've made me hungry for a burger.
I said nothing about a burger..?
Now you made me hungry too 
--edit
MacDonalds..
|
|
|
|
|
Hi All,
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.
'
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
Dim wbService As New WEB_APIs.Service
Dim ct_BundleBalanceDetails As WEB_APIs_SCBF.BundleBalanceDetailsComplexType()
Response.Write("Calling BundleBalanceRequest <br>")
Dim ResponseCode As String = wbService.BundleBalanceRequest(WEB_APIs_SCBF.InterfaceSimpleType.WEB, "03189719", ct_BundleBalanceDetails)
Response.Write("<br> BundleBalanceResponse ")
Response.Write(ResponseCode)
Catch ex As Exception
Response.Write("<br> API call is failed <BR>" & ex.Message)
Finally
End Try
End Sub
End Class
dadsadasd
|
|
|
|
|
If the BundleBalanceRequest just sets the ByRef parameter, you can either ignore the warning or set the variable to Nothing.
e.g.
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
