|
I have prepared a form in vb.net 2003. I have used a combo box & textboxes in that form. I used data adaptaer. A data Might not save in the table again. My back_end is SQL Server 2000. How can ido this?
|
|
|
|
|
Your question makes no sense. Presumably it has something to do with validation? Please try and explain yourself more clearly.
Paul Marfleet
|
|
|
|
|
PLease Provide me info on your post, and check your Spellings. what i can grasp from yourt statement , is that you dont want the data to saved again. i dont why, and i dont know when should that happen. please provide more info
thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
hi All
Yesterday i have post this Question, but i was long. let me cut it short. i have a BLL Class that has my validation, from my vb.net Form. and i have created a Class Component which is my DAL with all SQl statement. i want to know how to take the validated data from BLL and use it as input into my insert,delete,update statements or Procedure into DAl.
please Post example code or Article. am using vb2003
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Goto www.asp.net and read the tutorials
Dan
|
|
|
|
|
hi,
i am working in vb.net. now i want remove the word table.. how to remove the all table in microsoft word.. using vb.net.
anybody pls help me.... tell me code...
-- modified at 1:48 Tuesday 2nd October, 2007
vbg
|
|
|
|
|
Do not post programming questions (use the programming forums for that)
That's what was written in big red letters when you were posting this programming question to the lounge.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi,
I'm having a problem on my project here regarding the deletion of selected row on a DataGridView. The DataGridView I have is connected with a DataSet in SQL.
I have my recent code here:
Dim selRow As DataGridViewRow = Table1DataGridView.Rows(Table1DataGridView.CurrentCell.RowIndex)<br />
Table1DataGridView.Rows.Remove(selRow)<br />
Me.Table1TableAdapter.Update(Me.SampleDataSet.Table1)
I'm having an error with the last line saying, "Update requires a valid DeleteCommand when passed DataRow collection with deleted rows."
I'm thinking of a way on how will I send a Delete Command to the DataSet to delete the row I selected on the DataGridView.
Hope anyone could help me here..
Thanks!
ange(",)8
|
|
|
|
|
My guess is that in your table1tableadapter you have a select command and an update command, but not a delete command. When using a tableadapter these sql statements need to be defined.
This is what MS help says:
If INSERT, UPDATE, or DELETE statements have not been specified, the Update method generates an exception. However, you can create a SqlCommandBuilder or OleDbCommandBuilder object to automatically generate SQL statements for single-table updates if you set the SelectCommand property of a .NET Framework data provider. Then, any additional SQL statements that you do not set are generated by the CommandBuilder. This generation logic requires key column information to be present in the DataSet. For more information see Automatically Generating Commands.
Hope that helps.
Ben
-- modified at 22:24 Monday 1st October, 2007
|
|
|
|
|
ok thanks.. I'll try to check this out and how it will work..
I'll just ask here again if I have some questions..
|
|
|
|
|
I wanted to read the article in following heading
Automaticaly Match and Select ComboBox Item
did everything as is on the tutoriaL. but when i type in the combobox it doesnt set the correct text in the cmbbox.text field..
I am using vb.net not vb6. i changed the VB.LEFT to Microsoft.Visualbasic.Left.
what may be the problem?
fire
|
|
|
|
|
firebladeiii wrote: I wanted to read the article in following heading
Automaticaly Match and Select ComboBox Item
Did you find it here? If so, do an article search to find it again.
firebladeiii wrote: I am using vb.net not vb6. i changed the VB.LEFT to Microsoft.Visualbasic.Left.
what may be the problem?
Find the article and post a message. See if the author responds.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I have a web service project created using VS 2005(vb.net). I have a web method exposed that will be used by a remote client. I also want to fire the code in this method when the web app that exposes the web service starts (say from Application_Start in Global.asax).
Is there a way I can call this method from Global.asax?
Matt Melick, MCSE MCT
|
|
|
|
|
|
Thank you for the response but server.execute would not not be the proper way to access the public method within the service class.
|
|
|
|
|
sorry you did say webservice didn't you.... wouldn't you have to use an http call using either dotnet code or msxml dll?
you could also put the functionality into a dll. have your webservice reference that dll and your global.asax could do a load assembly to the same dll.
|
|
|
|
|
Further isolating the code may work but was hoping there would be a simple way to get to the method since its contained in a public class. Its possible I'm looking for an answer that doesn't exist, it jsut seems kind of limiting that once you enclose a sub in web method brackets that it can't some how be accessed through internal code.
|
|
|
|
|
I forgot how to do this and I am not exactly sure how to search for it. But I am displaying 2 texts in the same label but I want them to be on different lines. I have seen it before but I have forgotten how to do it can someone please help me!
Thank You!
|
|
|
|
|
use "\n" inside a string or look at the example below:
label1.Text = "foo" & System.Environment.NewLine & "second line"
|
|
|
|
|
I am trying to connect to the database through Microsoft by doing new project and selecting database but does not seem to be working, this is a new venture for me and i have an assignment that says i must do a database with oracle consisting of 3 or 4 tables and by use of VB.Net retrieve the information from the oracle database.
Thank You Beforehand
Kendo
|
|
|
|
|
Which part is not working ? Do you have Oracle running ? Do you know how to connect to SQL Server and the issue is Oracle ? There are Oracle specific classes in .NET, have you looked at the help for them ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i am reading up online at present and have been for the last 4 days but i just dont understand at present. Last year i created a database with access with front end VB.NET. Theatre booking system.
But i have never used oracle before and i just keep reading up online from oracle site but just keep bashing my head against a brick wall. I can get oracle running and go into create the table. I do not know how to connect to the SQL server.
Thank you
Its not that i am not reading up and trying to do on my own just seem to get know further than i was 4 days ago.
I will need all the luck i can get as Final Year Degree.
|
|
|
|
|
|
i have been to that document but clicked on other links on it but that looks to be the source that i am looking for just so much oracle and .net about out there which is confusing me.
Christian Thank You for the help i will work through that and will let you know how i get on.
You will never know until you give it a go!!!!
|
|
|
|
|
I have done what the link says but i dont seem to get any details back, the following does not copy and paste into SQL*Plus:
Listing 1
DROP TABLE emptab; <br />
CREATE TABLE emptab (empno NUMBER(4) PRIMARY KEY, ename VARCHAR2(10));<br />
INSERT INTO emptab VALUES ( 1, 'Mark');<br />
INSERT INTO emptab VALUES ( 2, 'Roger');<br />
INSERT INTO emptab VALUES ( 3, 'Crook');<br />
COMMIT;
I have typed it several times into the SQL*plus command prompt window but just keep getting SP2-0640: Not connected
below is print screen of walk through.
I take it you cannot post word docs in here.
When i type it in the SQL*plus command prompt window the SQL that is typed just stays on the same line until i get to the end of screen then jumps on to the next line. Is this the problem.
I have entered all the VB.net code in and dont have any errors in the code but i must display the details into some list box at present but and eventually into text boxes. Cant remember how to do this will get last years work out.
-- modified at 5:36 Tuesday 2nd October, 2007
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
