|
I am using a datagrid on my Windows form to display records stored in a SQL Server database. When the form loads the datagrid is populated with the records. When I select an item in the datagrid the values are displayed in some text boxes. So when i select a different row in the datagrid the text boxes change accordingly. This part is fine.
I then have two buttons, Add and Delete. I use SQL statements to Add and Delete records. The SQL statements are fine and when I check the table in SQL Server the Addition or Deletion has been successful. The problem is refreshing my datagrid. If i close the form and open it again the datagrid reflects the changes, but i want it to refresh without closing and opening the form. The code for the Add button is as follows:
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim Command As SqlCommand
Command = New SqlCommand("Insert into FitmentReasons(code,description, active) values ('" & txtCode.Text & "','" & txtDescription.Text & "','1')", gConn)
Command.ExecuteNonQuery()
txtCode.Clear()
txtDescription.Clear()
End Sub
|
|
|
|
|
after adding new record again bind the data to datagrid using select query.
|
|
|
|
|
You need to fill the dataset or datatable again and set the datasource to the datagrid.
|
|
|
|
|
Hai,
I am using grid with 1000 cols and 20 rows. In each column for some cells font is different than default fpnt. But this is giving out of memory error. What is the soulutions.
With regards
|
|
|
|
|
There is a maximum number of cells a MSFlexgrid can display. I cant remember the exact number and google isnt helping at the moment. From what i remember (from the problems we had) 1000 x 20 (and maybe a couple of fixed rows/columns) is probably pretty close to that limit. Try using the MSHFlexgrid instead.
Jon
|
|
|
|
|
hi, can anyone tell me about free ebooks for vb.net.
Himanshu Arora
VSNL
New Delhi
|
|
|
|
|
|
hello every body. I want to convert string to unicode and unicode to string. can you tell me.
|
|
|
|
|
String is first converted into ASCII and then to Unicode by character mapping and visa-versa!
I did the same thing while handling Hindi-fontcode. Hindi-font-Text was first converted into ISCII and then to Unicode & visa-versa. For that I used dlls...
All this thing is based on character mapping...
Padma Gahlot
|
|
|
|
|
|
Hi,
I am writing an addin tat adds a couple of menu items to various CommandBars in Visual Studio 2005. I have all the menu items working fine but I still have a few other things to get sorted out.
I am adding some menu items to the context menu of the Project Folder. I want them all to appear after the Build, Rebuild and Clean menu items. How can I add a seperator before my first menu item and after my last menu item?
I have added a few menu items to the context menu of the code window. How can I fix it so that these menu items are only displayed when the active document is either a .cs or .vb file?
How can I get rid of the icons that are added automatically to my menu items?
Thanks very much,
dlarkin77
|
|
|
|
|
I have a field in MSSQL server of date type which is nullable. I am checking the field from a RecordSet field but I am having the operation not allowed error
If rs.Fields("rdate").Value Is DBNull.Value Then
// Disableing the DateTimePicker
DateTimePicker1.Enable = False
else
//display the value in the DTP control
DateTimePicker1.Value = rs.Fields("rdate").Value
End If
Are their any other way to check null value of date type
Plz help me.
|
|
|
|
|
Is this VB6? rs.fields makes me think its VB6. DBNull.Value is a vb.net type and not available in VB6.
for VB6 try
if IsNull(rs.fields("rdate")) then
Jonathan
|
|
|
|
|
Hi Jonathan,
No, it is VB.Net. I tried the following
If rs.Fields("rdate").Value Is DBNull.Value Then
and
If IsDBNull(rs.Fields("rdate").Value) = True Then
But always get the error that the operation is not allowed for Date Type with DBNull type.How can I handle it even tried the
Public Function dNull(ByVal O As Object ) As Boolean
If IsDBNull(O) = True Then
Return True
Else
Return False
End If
End Function
but still getting the same error.So how to handle Null value in VB.Net for Date Type.
|
|
|
|
|
What technology are you using for the data access?
It doesnt sound like ADO.NET as there is no fields collection in any of the ADO.NET objects. Thats why i thought you were using VB6 because it looks like you are using classic ADO.
If this is the case then i would guess thats your problem.
If you havent imported the System namespace you could try that first as DBNull is actually System.DBNull but the 'Is DBNull.Value' syntax is correct. If that doesnt work then i would guess its because classic ADO does not expose a datatype of System.DBNull so i cant really see any way around it other than dropping the ADO recordsets and using ADO.NET's Datasets and Datatables.
Jon
|
|
|
|
|
Thanks Jonathon,
I used the ADO.Net Dataset and now the same code is working. Thanks for your replies.
Ronny
|
|
|
|
|
The above error is being displayed when trying to create a setup wizard for a .NET application.
Any ideas?
Jon
|
|
|
|
|
How to use control WebBorser in VB.NET 2005
................
|
|
|
|
|
Sir,
There is a string like "this is a string"
I want to select substring "string" programically.I mean at run time it comes in the label control in the selected format and the remaining substring will be unselected.
Like in msdn library a search keyword is entered .now the result description comes with the search keyword selected i.e having blue background of the search keyword.
Please help me.
Thanks and Regards
amaneet Brar
|
|
|
|
|
hi,
 i need to create a asp.net using vb.net program to manage sql server database users and groups, can someone advice the best way to do this, i was thinking of using sql queries to do this, but dont know where to start  ? is there other best way to this, or can give me links to article concerning this?
many many thanks guys!
regards,
 Stephen
---------------------
www.islasolutions.net
|
|
|
|
|
miceisland wrote: i was thinking of using sql queries to do this, but dont know where to start?
I usually start by working out what the application needs to do. I create a list of functions it performs. If there is a technology that I need to use that I don't know much about then I read articles about it, look at samples and build small test riggs to demonstrate to myself how it works.
miceisland wrote: or can give me links to article concerning this?
You can use your favourite search engine to look for "SQL Server" and "user", "group", "role", "login", etc.
Once you have some idea of what you can do and you have a specific query (rather than this vague query) then forums become a great place to get the answers to your questions. At the moment any answer can only be as vague as the question.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I am using form 2.0 control for displaying unicode text. I am able to copy the unicode text from that control to clipboard but fails to paste the unicode text from clipboard to form 2.0 control.
Also I am struck how to type in unicode in form 2.0 control!!!
Plzzzz help...
<plz give="" me="" any="" link="" related="" to="" these!="">
Padma Gahlot
|
|
|
|
|
Sir,
I am using connection string in the following format
Dim cnstr As String = "Provider=Microsoft.Jet.Oledb.4.0;data source=C:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\WindowsApplication1\db1.mdb"
But when I use connection string in the following format it shows error and connection does not get establishment.
Dim cnstr As String = "Provider=Microsoft.Jet.Oledb.4.0;data source=WindowsApplication1\db1.mdb"
I don't want to declare the full path.
Please help me
Thanks and Regards
amaneet Brar
|
|
|
|
|
amaneet wrote: I don't want to declare the full path.
Then try this (assuming that the MDB is in the application path):
Dim cnstr As String = "Provider=Microsoft.Jet.Oledb.4.0;data source=" & Application.StartupPath & "db1.mdb"
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
