|
just have time in database 19:30 and then pullit to datagrid but it shows a date in datagrid 30/12/1899 and then when i select a row from the datagrid to populate the text boxes it pulls the time i am a little confused but have not set any format for it.
|
|
|
|
|
I m working on a module where I fetch the table information from database, and display it in Datagrid.I am able to view all the records.
Actual procedure is :
User selects from the list of tables in the database, then select the operation to perform(Ex add, update,del,view) then that table information is displayed accordingly in the datagrid. At runtime the recordsource for the datagrid changes to the name of the table selected from the list.
Now when I do update to a table with non-numeric information i get the following error.
[Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG Column.
This error I searched on Internet, it says to check for any data conversion that is done in the coding. But I have only fetched the data in Adodc & updated there itself.
Can any one help me to solve this problem.
Upma
-- modified at 5:45 Wednesday 21st February, 2007
|
|
|
|
|
Hi Upma,
The conversion in your case is implicit.
Upma wrote: Now when I do update to a table with non-numeric information i get the following error.
You are trying to convert a long to a string. You should probably set the column in the table to long.
Good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
dataadapter update method problem
sanjiv raj rao kusuma
|
|
|
|
|
sanjiv raj wrote: dataadapter update method problem
Care to give us more details about your "dataadapter update method problem"? It is very difficult to help with so little information. It is like phoning a mechanic and saying "car driving problem"
|
|
|
|
|
i cannot add reference file "csMusicMedia.dll" into my VB.NET application as a library file.
the error says,
"this is not a valid assembly or COM component. only assemblies with extension 'dll' and 'COM' components can be referenced. please make sure that the file is accessible, and that it is a valid assembly or COM component."
but the .dll file i using ia a valid library file.
|
|
|
|
|
siva503 wrote: but the .dll file i using ia a valid library file.
"library"? C and C++ produce libraries. .NET languages produce assemblies. You cannot add a library file to a .NET application unless you use DllImport.
|
|
|
|
|
does anyone knows on how to disable local area connection progmatically?
|
|
|
|
|
Hi All,
I need to add a help file within my system (i.e: steps to use the system), I have searched in all items imbedded within VS 2005 but I did not file item like help file. Is there any body who may help ???
Kind Regards
OBarahmeh
Palestinian Central Bureau of Statistics (PCBS)
Ramallah-Palestinian Territory
|
|
|
|
|
You have to install the MSDN Library to get the documentation. This comes with every version of Visual Studio, except the Express Editions (I think! - I don't use them).
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
When I send the data to the server, the server forms an xml of the data and sends me the url to that xml.
Now, I am needed to save this xml into a particular directory(already known).
How to I read and save this file ?
I am not having a trace of the flow with me, so I dont have an idea how I will get the data in the xml and furthur will save it.
Can anyone help me to know how can I read the xml from the url to the xml and how do I save this file into a directory
|
|
|
|
|
using a Sql Server DB , and having a field 'ID' with a 'varchar' datatype,
how can i set the criteria of this field to be : unique No dupplicatate (like MS-Access)
to dissallow the user to enter the same value twice
thx
Regards
Ramy
|
|
|
|
|
you can set the primary key for that field so that you can prevent the dupliacates
Sathesh Pandian
|
|
|
|
|
sathesh_pandian wrote: you can set the primary key for that field so that you can prevent the dupliacates
Which is not a valid thing to do if you already have a primary key! Do NOT set a column as a primary key just to make it unique. There you can apply a unique constraint to columns.
|
|
|
|
|
When you create your table you can do something like this:
CREATE TABLE dbo.MyTable
(
MyUniqueColumn varchar(30) NULL UNIQUE NONCLUSTERED
)
|
|
|
|
|
how to read the long binary data from the MS ACCESS database? and storing in the another Document file.
|
|
|
|
|
Hello
How can i work with the Microsoft Multimedia Control (Version 6.0)
in vb.net?
More Info : you can add it to your form :
Tools-->Choose Toolbox Item--->COM and find it !
|
|
|
|
|
How do you generate lm and nt hashes using visual basic for a given password?
Radiit
|
|
|
|
|
Why? I'll give you a hint - it's an MD5 hash that is easily broken now-a-days. Other than that, I question the motivation behind asking such a question.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
gud morning frends,
Will anyone tell me what is the difference between Datagrid & datagridview in VB.nNet.
Thanks for any help in advance
-Regards Priyanka.
I AM NOT THE BEST
BUT I AM NOT LIKE REST 
|
|
|
|
|
Differences Between the Windows Forms DataGridView and DataGrid Controls
The DataGridView control is a new control that replaces the DataGrid control. The DataGridView control provides numerous basic and advanced features that are missing in the DataGrid control. Additionally, the architecture of the DataGridView control makes it much easier to extend and customize than the DataGrid control.
The following table describes a few of the primary features available in the DataGridView control that are missing from the DataGrid control.
DataGridView control feature Description
Multiple column types
The DataGridView control provides more built-in column types than the DataGrid control. These column types meet the needs of most common scenarios, but are also easier to extend or replace than the column types in the DataGrid control. For more information, see Column Types in the Windows Forms DataGridView Control.
Multiple ways to display data
The DataGrid control is limited to displaying data from an external data source. The DataGridView control, however, can display unbound data stored in the control, data from a bound data source, or bound and unbound data together. You can also implement virtual mode in the DataGridView control to provide custom data management. For more information, see Data Display Modes in the Windows Forms DataGridView Control.
Multiple ways to customize the display of data
The DataGridView control provides many properties and events that enable you to specify how data is formatted and displayed. For example, you can change the appearance of cells, rows, and columns depending on the data they contain, or you can replace data of one data type with equivalent data of another type. For more information, see Data Formatting in the Windows Forms DataGridView Control.
Multiple options for changing cell, row, column, and header appearance and behavior
The DataGridView control enables you to work with individual grid components in numerous ways. For example, you can freeze rows and columns to prevent them from scrolling; hide rows, columns, and headers; change the way row, column, and header sizes are adjusted; change the way users make selections; and provide ToolTips and shortcut menus for individual cells, rows, and columns.
The DataGrid control is retained for backward compatibility and for special needs. For nearly all purposes, you should use the DataGridView control. The only feature that is available in the DataGrid control that is not available in the DataGridView control is the hierarchical display of information from two related tables in a single control. You must use two DataGridView controls to display information from two tables that are in a master/detail relationship.
Sathesh Pandian
|
|
|
|
|
Function SelectReportServiceAndDate(ByVal FromDt As Date, ByVal Todt As Date)
Try
'Myconnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=KanServicesDB.mdb;"
MyCommand.Connection = Myconnection
MyCommand.CommandText = "Select * from GKRST"
MyCommand.CommandType = CommandType.Text
MyDA.SelectCommand = MyCommand
MyDA.Fill(myDS, "GKRST1")
All.SetDataSource(myDS)
'All.RecordSelectionFormula = "{GKRST.Dttime}>=#" & Format(FromDt.Date, "mm/dd/yyyy") & "#"
All.RecordSelectionFormula = "{GKRST.DtTime}>=#" & Format(FromDt.Date, "M/dd/yyyy") & "# And {GKRST.DtTime}<=#" & Format(Todt.Date, "M/dd/yyyy") & "#"
'All.RecordSelectionFormula = "{GKRST.DtTime}>=#" & Now.AddDays(-1) & "# And {GKRST.DtTime}<=#" & Now & "#"
CrystalReportViewer1.ReportSource = All
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Function
Hi, I have a problem while selecting between two dates. In my database "Kanservices.mdb" have a Date Column like 'DtTime'. It has both date as well as time. The above code is select between two dates.Its not working properly. If i store the Date in the DtTime column its working. If i store Store Date&Time the problem occurs.
Plz give the solution.
Thanks & Regards
Kumaran
|
|
|
|
|
Two words: "Parameterized Queries".
If you try and concatenate strings together, like you are in this code, you have to worry about putting the strings together with the correct date format. Using parameterized queries, the Parameters objects take care of that for you! You don't have to worry about getting the format right!
You can find out more about them in Colin's article SQL Injection Attacks and Some Tips on How to Prevent Them[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hello,
I need help in my VB application.
I have a 'Browse' button in my application's properties page, which should help me to browse through the directory system to choose a directory to save the xml files into.
How to I get the directory system when I click on browse.
In C# we have the 'FolderBrowserDialog' , do we have something like that in VB.
Also how do I save files into the directory choosen by 'browse'
|
|
|
|
|
yes. In vb.net we have the same 'FolderBrowserDialog'.
you can use it for the folder selection.
Sathesh Pandian
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
