At the following cmd.ExecuteNonQuery() line, I get the following error message: [code] I have followed the example at page [code] as closely as possible, but it does not work.Additionally, I am not sure of the syntax for the length (64) that I have for the BigInt or if it should even have a length.All of the examples that I have found in MSDN uses only parameters with character rather than numberic type. [code]
View 6 RepliesI have a DetailsView that I am using to insert an enrollment form into the database. Currently every functions fine, with one exception. Since there is a terms and agreement checkbox at the bottom of the form that I cannot validate using the existing validation controls, I'm trying to handle this in the VBScript.The problem is that the InsertCommand in my ASP executes before the Button_Click sub does, so the form is submitted before the checkbox validates. Can someone tell me how to move the InsertCommand from the ASP to the code file so that I can make sure it doesn't execute until AFTER my button validation? Here is my code:
[Code]...
Public Shared Function getJoinedTable() As DataTable
connect()
updatableAdapter(1) = New OleDb.OleDbDataAdapter("SELECT a.id, a.number, a.subjectName,
[code].....
In my form, there is a (design time) dataadapter. This adapter has got Insert, Update, Delete and Select commands. When the InsertCommand is executed, the data in the form are inserted (and saved) to the database.
The InsertCommand has a parameter RETURN_VALUE. The value of the parameter can be read by the follwoing code.
pDataAdapter.InsertCommand.Parameters("RETURN_VALUE").value
I want to assign the above value to another field in the dataset (say, SubscriptionNo) I use the following
pPKValue = pDataAdapter.InsertCommand.Parameters("RETURN_VALUE").value
pDataSet.Tables(pDataSetTable).Rows(0).BeginEdit()
[CODE]...
But, when I assigned the pPKValue, it raises the error, "Column SubscriberNo is Read-Only". How to rectify it? I like to set this as "NON Read-only" temporarily and after updating, again set to read-only.
what is the method to insert a row in a table using Insert-Command and a DataAdapter. I want to insert the row using SQL = "INSERT INTO table (f1, f2) VALUES (@p1, @p2)". [Code]
View 10 RepliesTake a look at this code. The OLEDB command builder does not create insert command nor delete or update commands.
View 3 RepliesI'm trying to get a database to add a new row on this form. The user types a word into a text box, clicks save, and it should update the database. The table is called "text" for now, it's an Access DB, and it has two rows: ID, and userText. [Code]
I get the error at the da.Update line when I click Save. The full error is "Update requires a valid InsertCommand when passed DataRow collection with new rows." I'm not sure if I have to add an INSERT command somehow or if something in the code needs changing. If I add this line to the Save routine, I get an "Syntax error in INSERT INTO command": Dim cb As New OleDb.OleDbCommandBuilder(da)
I don't know if I should leave that out or keep it in since both give me errors.
I am connected to a MYSQL database and the following Insertcommand works fine:
InsertCommand="INSERT INTO suppliers (Supplier) VALUES (?Supplier)"
Now when I want the option of updating all the columns it keeps saying "Column 'Contact_2' cannot be null" or contact_1, so all the fields need something and not all suppliers of course have two numbers. What am I doing wrong? here is the
InsertCommand="INSERT INTO suppliers (Supplier, Contact_1, Contact_2) VALUES (?Supplier, ?Contact_1, ?Contact_2)"
I'm getting an error when the 'insertcommand' is executed telling me that I'm missing the parameters for the stored procedure. Do I need to put the parameter names in the Sql statement after the procedure as if I were calling it in SQL? I saw an example online that just added the parameters like I have here, but this doesn't work? I also put the sql state for the stored procedure below the 'AddRepair Sub'
Public Shared Sub AddRepair(ByVal repair As ClubRepair)
Dim conn As SqlConnection = ClubRentalsDB.getconnection
Dim insertcommand As New SqlCommand("AddRepair", conn)
[CODE]...
[code]....First of all, when using "Using", is the Open() method required? Some I've seen with, some without. Pretty sure it worked in both cases. Also, I've seen some that end with the Close() method before the End Using.Is that necessary? Basically, when is Open() needed, when is Close() needed, and why is Using/End Using needed at all?
**EDIT: For some reason the "Insert Code Block" isn't working properly at colouring the code.
Here is my code.....This code works fine but when I click on add button (Which is used to update record) the following exception/error comes
View 6 RepliesI'm still pretty new at .Net and database coding, and am working on a small program that is generating an error and I'm not sure how to resolve it.[code]The following statement is giving me the error below: m_DA.Update(m_DataTable)"Update requires a valid InsertCommand when passed DataRow collection with new Rows".I know the answer is going to be very simple, but I'm at a loss. I would greatly appreciate it if someone could point out the flaw in my code and how to correct it. And yes, I have done fairly extensive searching on this error, but none of them give any idea how to fix it, they just hint around at what's wrong.
View 9 RepliesI have been given an old dll and the assignment of accessing it through C# .NET 3.5. I believe the dll was originally built with VB6, but am not positive. There is no documentation or source for the dll aside from an example for how to use the it in VB6. I have been able to succesfully access it through VB.NET 3.5. Example code for accessing looks like this:
myLib = CreateObject("MyLib.api")
myConnection = myLib.CreateObject("NameOfConnectionObject")
myConnection.do_something("abc")
There are several different objects that are created from the library and all of those objects have different methods. I tried using different dll reading tools, but all the export methods show up as garbage. I also tried importing the dll in visual studio, but I get an error stating the dll is not accessible and/or not a COM object or assembly. So, I only know about the methods from the old documentation which is sparse. how to access in C# and/or find out more about this mystery dll?
i cant understand what constants are.
View 3 RepliesPrivate Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
Dim d As Integer
Dim price(20) As Double ' Adjusted close price
[code]....
What is the for ... next loops in the second subroutine doing? What is the sim() array meaning?
I have a modem that I've been trying to communicate with only to discover this....went to the modem properties and queried the modem.....
AT+FCLASS = 0,1,8
AT#CLASS = ? COMMAND NOT SUPPORTED
(And I had been trying to use AT#CLASS = 8 all day).So, what does this mean?That the modem is automatically in voice mode (or will automatically choose it's own mode) and forcing it isn't necessary?Still no luck with the connection response messages either -- RING, etc.All I can do is make a call and the called number will appear in a textbox.
I've done an internet search to determine if I can detail if a SQLDataAdapter is empty after running an SQLCommand? My research so far point I can't check if the SQL dataAdapter is empty until I bind it to a dataset/datatable. Ideally would not like to run another SQL command to do a row count to determine if query retruns rows or not. I'm populating a datagridview and would like to alert the user that there is no data to view. What's the most efficent way to check if an SQLDataAdapter is empty?
View 4 RepliesI'm not even sure what I'm asking is even possible, but here goes:
Is there a way to loop through a sqlDataAdapter to find multiple tables?
Currently I have a module that you pass in an object and it automatically fills the parameters of a stored procedure with the values of the object. It works great, except when the stored procedure returns more than one table, it only returns the first one.
Here is what I tried to get to that second table:
Dim ds As New DataSet
Dim table As New DataTable
Dim reader As SqlDataReader = command.ExecuteReader
[Code].....
I have the followin problem. Opening a table using SqlDataAdapter, numeric columns(sqlDbType = int16, 32, 64) that allow Null value, are set in my dataRows to 0.I am using Visual Studio 2010 and Sql Server 2008.Here's my code:
Dim cmd As New SqlCommand
Dim ds As New DataSet
Dim dt As DataTable
[code].....
I am fairly inexperienced with using datatables in VB. My question is this: Can I access a particular column of a table by name if it is not defined elsewhere like when I populate a datatable using sqldataadapter.
[Code]...
Is this the way it can be done? I believe this is the case, but can't find any definitive examples online (probably not searching properly)
I'm moving over date.oledb commands to SQL ones and wondering what the equivalent to executenonquery here is? This is what I have at the moment and I can bind select queries to datagrids no problem how would I get the DBCommand to execute the query?
Dim DBConn As SqlConnection
Dim DBCommand As SqlDataAdapter
Dim DSPageData As New DataSet
[code].....
I have an empty table loaded to the datagridview. I add a new row to the table by
[Code]...
This code works fine, if i add a new row to the table in which some rows already exists. (Works only when after inputing data to the new row I select any another row). But when I use this code for the first row in a table, it creates a new empty record in the database. The data I have inputed into the datagirfview fields aren`t saved.
This was working on the last test, now it's throwing an InvalidOperationException saying Update requires a valid InsertCommand when passed DataRow collection with new rows. No change in this
Dim NewRowB as DataRow=dsBatch.Tables("Batch").NewRow
dsBatch.Tables("Batch").Rows.Add(NewRowB
daBatch.Update(dsBatch,"Batch")
What *has* changed is that I'm trying to fix the same error that's occurring on a different dataset in a different form. This should add a blank record to the dataset, then update the database. The blank fields allow nulls. The reason for this (and there may be another way to do this-I'm helping a novice fix up his code and, since this has been working, I haven't yet really looked at it) is to obtain the correct value for an identity field. We've found that when the row is added to the dataset, if it doesn't currently contain any rows, the identity value is set to zero-but when the database is updated, it gets a different value (because previously inserted rows have been deleted). So we update the database then retrieve the correct identity value before continuing.As I said, this was working fine-until I started working on the same problem occurring in a different dataset. So why would that affect this dataset?
I am getting a build error. If I try to build again after getting this error, it will build just fine.
View 9 Replies[code] I cannot seem to understand why left & lan isn't working in the vb 2008 edition
View 2 Replieshow to understand a msakeditbox in null?
View 4 RepliesI've been trying to understand classes and objects. Yes, I'm thick headed and slow, but I made the decision to go to .Net and I am determined to improve my coding skills to be more efficient. I have spoken to Atma several times on the topic and read most of his posts concerning classes and objects, but still came away a little baffled (He's really advanced for me yet). I needed a simplistic analogy for a reference point to begin understanding. I was reading about OOP written by MikeJ in the following thread/post ...[URL] and it all started to become clear in this statement , but I would like some reassurance that I'm getting it ..."A car IS-A vehicle, while a dog HAS-A tail. The car would be an object declared as type Vehicle, while the dog would have a member that IS-A tail. However, Fido IS-A dog. The dog class is the base template for all dog objects, so when we declare Fido as a dog, Fido is an object. Since Fido IS-A dog, Fido HAS-A tail."
From this I have taken the following understanding...
Vehicle ... ' Class
Car ....... ' Object
Truck ... ' Object
Van ....... ' Object
And from that can I infer that this is true?
Dog ....... ' Class
Fido ... ' Object
Tail .. ' Member of Fido
So to apply this to a program I wrote recently that tracks Generator service...
Generator ' Would be the class
Brand X ' Would be an object
Spark Plug ' Would be a member
Gas Tank ' Would be a member
Brand Y ' Would be an object
Brand Z ' Would be an object
This statement also helped ...
""Class" and "object" are sometimes used interchangeably. However, classes describe the structure of objects, while objects are instances of classes. Each instance is an exact copy of its base class. Because an object is an "instance" of a class, the act of creating an object is called instantiation. To describe it better, a class is a blueprint, and an object is a building based on that blueprint". I can understand this (I think) and it refers to a basic template such as ..."Generator" (my class or blueprint or template) Generators have an engine, powerplant, fuel tank, etc. These are basic requirements to be a generator. (Template or Blueprint) They can differ by Brand of engine, Size of powerplant, and type of fuel used. (Based on template or blueprint) Do I have it down now? MikeJ also made this statement ..."you can't access certain types of class members from outside of the class itself." From this I assume you would need to assign a Global variable the value of the class member if you needed to use it outside of the class?
I'm just getting back into VB and was never a pro. The last environment I was in, briefly, was VB6 but spent a good amount of time coding in early VB's back to QB.I'm trying to read RSS feeds and found a nice demo reader but now I want to understand the code I'm seeing:[code]
1. Why does the demo create a new XML to read through an existing XML or is this all in memory as I can't find an actually file? Is this even needed as what I want to do is read the RSS feed, grab some info from it (Source, Title of each story, Date stamp, author and the story text) and then process that in various ways (not actually view it... I want to e-mail specific stories directly to me that fit my search criteria). Or is this just opening the XML out on the web? That would explain why sending it "test" gives me an error saying it can't find "test" in the bin folder as without an HTTP address it goes local.
2. doc.load... what check can I perform here to be certain that the data entered by the user is actually a valid feed? It should, for example, have a first line header that is reliable but is that the best method?
3. Where or how are the elements stored that I can then refer back to pull the data out I want?
4. I don't understand how this part works: navigator.Select("/rss/channel/item/title") Can someone shed some lite on the 4 pieces at the end?
5. I'm assuming the clean-up isn't really needed for e-mail but I didn't remove it as it doesn't seem to harm anything.
I have Visual Basic 2010 and also bought a book to study and practice problems. I know how to add controls and assign properties but get confused with the coding part.understand this somewhat?
Here is one problem I am working on-
Write a program to make change for an amount of money from 0-99 cents input by the user. the output of the program should show the number of coins from each denomination used to make change.
Now I know what controls i need on the windows form but I am sorta lost on the coding to make this program work.
I am having trouble inserting data to a DB using a dataadapter. Here is the code:
Dim daDevices As New SqlDataAdapter(sql, MyConnObj)
Dim dsDevices As New DataSet("WORKSHOP")
daDevices.FillSchema(dsDevices, SchemaType.Source, "Replacements")
daDevices.Fill(dsDevices, "Replacements")
Dim tblDevcies As DataTable
[Code] .....