|
HI
From reading the link, it seems the data is not actually cast to any datatype, it is only constraints, allow dbnulls etc that is set with fillschema.
If a database datatype is for example char 3, and you use the upadte method of the dataadapter with any string, as long as it's less than 3 chars long will that be ok? Then what about date? the dates are displayed as 00-01-1900 00:00:00, but that is normally a number, and it is only formatting that shows it in that format.
The other part I dont understand, if you pull data from the table, and then get the datatype for each colum of one of the rows, the columns of each row have definite datatypes (If dr is a row of dt and you go dr.Item(0).GetType.Name.ToString you get various datatypes for each column of the database, that sort of match the database datatype - i.e. double in db = double, char 3 in db = string, date 4 in db = datetime etc. How are these datatypes set in the table when you retrieve data via the DataAdapter?
|
|
|
|
|
Hi,
I have a combobox which binds to a table column named TestTypeId.
I have a seperate table (within the same dataset) named tblTestTypes(TestTypeId, TestDesc)
I want the dropdown list of the combobox to display the TestDesc, but the actual data saved to my original table must be TestTypeId.
In Access this was easy, the control source property specified what was saved, while the row source property specified what data is displayed in the dropdown list.
In .Net I haven't the faintest idea how to tackle this! I can only choose from one DataTable as the DataSource, the ValueMember and the DisplayMember!
Any help would help! 
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
The data binding of a combobox only serves to populate the dropdown list. To save the data you have to write some code.
---
b { font-weight: normal; }
|
|
|
|
|
Nooooooooooooooooooooooooooooooooooooo!!! 
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
Don't you just hate it when coding actually involves writing code... 
---
b { font-weight: normal; }
|
|
|
|
|
I prefer writing code, but it yanks my chain when a new version of a control has less functionality than the older ones! Writing code for this will require an extra SQL connection which will result in extra overhead!
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
It's not a new version of the same control, is a completely different control in a completely different environment. When you use a control in Access, you are actually inside the database application itself, that's why it can bind the control to a specific record. Now instead you are in a Windows application and are communicating with an external database.
---
b { font-weight: normal; }
|
|
|
|
|
Then they shouldn't have called it a ComboBox.
The one I used in Access linked to an external SQL Server, via the linked tables.
Why can't the one in .Net do the same via datasets?
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
evilnoodle wrote: Then they shouldn't have called it a ComboBox.
In that case the control in Access shouldn't be called a combobox either. A combobox is just the windows control that is used to select an item, it's just a graphical object, it has no database capabilities at all.
evilnoodle wrote: The one I used in Access linked to an external SQL Server, via the linked tables.
Why can't the one in .Net do the same via datasets?
Simply because it's not built that way. Usually a control doesn't update the database by itself, but a combination of several controls form the data that is going to update the datbase. Supposing that the data is meant to update the database at all, that is. That is far from always the case.
---
b { font-weight: normal; }
|
|
|
|
|
After hours and hours of trial and error (and with some help) I managed to do with the combobox what I thought (and read) was impossible. And it was afterall possible to do it without code.
Next up: Doing this with a combobox with multiple columns... 
In MS Access all of the above (including the multi-column combobox) would take approx. 5 minutes to do.
I guess .Net teaches programming like Mr Miyagi teaches karate, through hardships, tough-love, and seemingly unnecessary repetitive tasks.
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
I wonder if someone could answer this question.
I am running VB.Net 2003 using .net framework 1.0. Will there be any problems installing .net framework 2.0. Will it make any difference.
|
|
|
|
|
No, both frameworks can sit side-by-side. You'll get an additional tab in IIS called ASP.NET because you'll have to tell IIS which version of the .NET Framework the web application is running in.
|
|
|
|
|
how to write the Query to exclude a row that the will not be taken
i have to write a query in which i do not want to include one row how do i write the query?
|
|
|
|
|
Rmesh wrote: i have to write a query in which i do not want to include one row how do i write the query?
That is a bit vague. You write the WHERE clause in the SQL Query to exclude the thing that you don't want. So, for example if you don't want a row where the Surname column is "Smith" you'd write:
SELECT ColumnNames FROM TableName WHERE Surname <> 'Smith'
|
|
|
|
|
how to print the variables in textbox
rx:
dim i as integer=10
dim j as integer=23
textboxbox1.text=(i,j)
if i give like this it show error
what is the result
|
|
|
|
|
Rmesh wrote: textboxbox1.text=(i,j)
textboxbox1.Text = (i.ToString & j.ToString)
|
|
|
|
|
What are you trying to get by printing (i,j)? Do you want the .Text property of the TextBox to be "(10,23)"? If so, you need to take the .ToString method of both integers and print that instead.
Try this:
Dim i As Integer = 10<br />
Dim j As Integer = 23<br />
<br />
TextBox1.Text = "(" & i.ToString & "," & j.ToString ")"
That should do it for you.
Jonathan Sampson
www.SampsonResume.com
|
|
|
|
|
Hey Guys
Kindly help me with the following function in vb.net 2005
I want to write a function that does the following
1. Go to pixels (x,y)
2. Draw a circle or a rectangle at the above pixels,
3. fill a circle or rectangle with a color
I guess it should be as follow
Public function draw (color,location_X,location_Y int, shape)
Fillellispse(…)
Shape: rectangle or circle
Color: RGB
Location x , y : are designed for pixels location
Regards
Ramy
|
|
|
|
|
Sounds a bit like a homework assignment to me. Have a look at the Paint[^] event.
|
|
|
|
|
we use this method, i don't know if it could be helpfull;
plz could you me to do a function using tis method
Protected Overrides Sub OnPaint(ByVal e As PaintEventArgs)
Dim g As Graphics = e.Graphics
Dim brush As SolidBrush = New SolidBrush(Color.Blue)
g.FillEllipse(Brushes.Gold, 550, 225, 20, 20)
End Sub
P.S: I need The "OnPaint" event to be used dynamically
Regards
Ramy
|
|
|
|
|
in my project i want to place link label over datagrid control at specified column it canbe varying at run time when number of records increases
|
|
|
|
|
in msgbox i would like to get values like this (2,4) how to do that
|
|
|
|
|
What do you mean? The messagebox should show those values? You'd like to get dialog results from the messagebox? What?
|
|
|
|
|
MsgBox("(2,4)", MsgBoxStyle.OkOnly, "My Message")
or
dim i as integer,j as integer
i=2
j=4
MsgBox("(" & i & "," & j & ")", MsgBoxStyle.OkOnly, "My Message")
Eric H.
|
|
|
|
|
Hi all,
Can anyone please point me a direction,if possible, for i to develop an vb form that mimics the Windows Desktop.
This form should be able to have icons, a taskbar and have other form on him.
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
