|
This will only work depending on how you've drawn your image, but....
PictureBox1.Image.Save(filepath)
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Jups that worked thanks Dave 
--Zaegra--
|
|
|
|
|
Hi this is Tracy here.
I'm doing a form created from Visual Studio 2005 which contain a "Add" button and a DataGridView. If the records are successfully added, it will be inserted into the SQL server database. I am trying to insert records into my SQL Server database without retrieving any information first.
But my program can't work and I don't know where it had gone wrong.
Here listed my codes when the user click on the "Add" button for the DataGridView:
'Add Button For DataGridView
Dim sqlcom As SqlCommand = New SqlCommand()
Dim mySqlDataAdapter As SqlDataAdapter
mySqlDataAdapter = New SqlDataAdapter
Dim myDataSet AsNew DataSet()
Dim mySqlcb As SqlCommandBuilder
mySqlcb = New SqlCommandBuilder(mySqlDataAdapter)
mySqlDataAdapter.InsertCommand = mySqlcb.GetInsertCommand
mySqlDataAdapter.Update("TBReqDG") 'ERROR COMES FROM HERE
'Open connection, execute the commands
sqlcon.Open()
'Close Connection
sqlcon.Close()
But there is still an error as shown below:
Error 1 Overload resolution failed because no accessible 'Update' can be called with these arguments:
'Public Function Update(dataTable As System.Data.DataTable) As Integer': Value of type 'String' cannot be converted to 'System.Data.DataTable'.
'Public Function Update(dataRows() As System.Data.DataRow) As Integer': Value of type 'String' cannot be converted to '1-dimensional array of System.Data.DataRow'.
'Public Overrides Function Update(dataSet As System.Data.DataSet) As Integer': Value of type 'String' cannot be converted to 'System.Data.DataSet'. C:\Documents and Settings\Administrator\Desktop\CCC\OfasERP_New PartII\OfasERP\frmRequisitionVoucher.vb 246 9 OfasERP
Hope to receive reply soon as it's urgent & thanks   
Regards
Tracy
|
|
|
|
|
It doesn't work because you haven't created a usable SqlDataAdapter. When you create one of these, you have to give it, at the very least, the Select command used to retrieve records out of your database. The SqlCommandBuilder then uses that SELECT query to build a matched UPDATE, INSERT, and DELETE query. When you called GetInsertCommand, nothing happened because there was no information usuable to build the INSERT query. Give it a SELECT command before you call anything on the SqlCommandBuilder object.
Dim conn As New SqlConnection(connectionString)
Dim da As New SqlDataAdapter("SELECT RecId, Name, Address FROM Customers", conn)
Dim cb As New SqlCommandBuilder(da)
da.InsertCommand = cb.GetInsertCommand()
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi Dave and Everyone
I had done my sqlconnection in the public area.
I am trying to insert records from DataGridView into my SQL Server database without retrieving any information and I do not require to retrieve records from database. Initally, the database in SQL Server is empty. For this program, I made use of the SqlDataAdapter, DataSet and BindingSource.
This is my latest codings as listed below:
Dim sqlcom As SqlCommand = New SqlCommand()
Dim da As New SqlDataAdapter("SELECT * FROM TBReqDG", sqlcon)
Dim myDataSet As New DataSet()
Dim cb As New SqlCommandBuilder(da)
da.InsertCommand = cb.GetInsertCommand()
da.Update(myDataSet, "TBReqDG")'ERROR COMES FROM HERE
'Open connection, execute the commands
sqlcon.Open()
sqlcom.Connection = sqlcon
'Close Connection
sqlcon.Close()
As my program runs, it show this error Update unable to find TableMapping['TBReqDG'] or DataTable 'TBReqDG'.
Is this line really necessary or I just only have to declare the sqldataadapter ?
-->Dim da As New SqlDataAdapter("SELECT * FROM TBReqDG", sqlcon)
I don't know where it had gone wrong and hope anyone who knows is able to guide me along.
Hope to receive reply soon as it’s urgent & thanks.
Rgds
Tracy
|
|
|
|
|
Hi everybody here,
I want to know ur preferences for 1 thing that I really likeee so muuch - GDI+ or Graphics in VB.Net.
- Which is best book about GDI+ in VB.Net ???
I really appreciate ur help ...
|
|
|
|
|
|
Kulazfuk this forum isn't meant for such stupid answers, please respond normal or just say nothing. 
|
|
|
|
|
Zaegra wrote: this forum isn't meant for such stupid answers
Nor is it meant for such stupid questions.
|
|
|
|
|
You we're saying something about "stupid answers"... You might want to check your own before judging someone elses.
And it is rude to yell like the OP did. The font size and bold was a bit over the top.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hmmm... not wanting to start an argument here but how many of my "stupid" answers have you had to correct? None that I can recall.
No need to get personal.
|
|
|
|
|
One, as of now. I never said I needed to correct any of your answers.
Or did yout just replay to the wrong person?? Maybe you were looking to reply to Zaegra??
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Oops! Sorry Dave! I got it all arse about face. Deepest apologies - I read your reply last night, thought you were having a go at me & got even more defensive.
Once again my apologies & thanks for pointing this out. Not sure if you're a drinking man but here, have a ![Beer | [beer]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/beer.gif)
Mental note 46 394 571 984: Read CP posts more objectively.
|
|
|
|
|
Hey .... have u get any illness,,,,
I am ask xperts not ... stupids/////
great job ...kulazfuk hahhaha LoL voilaaa
|
|
|
|
|
b3t1m0s wrote: I am ask xperts not
After posting a grand total of 3 posts, none of which are providing advice from your extensive experience, I seriously doubt you have any idea of what an expert is.
idiot alert...
|
|
|
|
|
|
The "best book" is going to be the one that is appropriate for your skill level. If you already have a decent background in GDI+ and VB.NET, then a beginner's book isn't going to be the "best". The opposite is also true. If you have no experience in GDI+, then an advanced book is going to be way over your head.
The point is you are the only one who can say which book is the best for you! All we can do is make some suggestions. You're still going to have to do the research to pick what's "best".
Amazon results for GDI+[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Sir,
How can i hide a column in the datagrid .
Please help
Thanks
|
|
|
|
|
DataGridName.Columns.Remove("Coulmn Name which u want to remove")
Vikash Yadav
|
|
|
|
|
Sir,
Thanks or the reply
I wanted the answer in .net version and that i have mentioned .
actually the datagrid1.columns class does not exist in .net.
please help.
Thanks
|
|
|
|
|
i also using vs.net 2005 in this it is working.& it is in datagridview class. just scroll down u will find it.
Vikash Yadav
|
|
|
|
|
Set the column mapping type hidden as below:
ds.Tables("yourTableName").Columns("columnYouWantToHide").ColumnMapping = MappingType.Hidden
|
|
|
|
|
This guy asks about 5 questions every week...seems to be homework questions.
|
|
|
|
|
I have one treeview on my form. now when user check one node of tree view this node added in my datagrid with one single datatable created at run time. now when user add child node of same parent i want to add same child in the child row of same datatable and in the gridview as child row. So how can i do that?
TC
|
|
|
|
|
I can't follow this at all...
I'm guessing at what you want here... Datatable rows don't get children. You have to design your table so that each record has a field that points to a parent records primary key in the same table.
RecordID bigint
Name nvarchar(50)
ParentID bigint
Each record has it's own unique RecordId. If a record has a parent, you set its ParentID to the RecordID number of the parent.
RecordID Name ParentID
------------------------------------
1 Mike 0 (0 means "no parent")
2 John 1 (John is a child of Mike)
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
