I am looking to define data types by fields in SQL Server 2005. My source is an Excel spreadsheet and I cannot define by columns because each row requires a set of definitions applied to each field in that row. Ex, row 1 requires field1 to be CHAR while in row 2 field 1 needs to be DATE.
View 1 RepliesI have this sql statement:
CREATE TABLE [dbo].[User]( [UserId] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [MiddleName]
[varchar](50) COLLATE SQL_Latin1_General_CP1_CI_A
What I want is regex code which I can use to get all fields and data type. So will return something like that:
FirstName varchar
MiddleName varchar
The sql statement will always have this format. I am using .Net to run this regex
I used to do this is VB6:
Type Record
A As Long
B As String
End Type
Dim Rec As Record
When I keyed in "Type" in my declarations, I was asked to change it to "Structure". After that, I was not able to define anything inside. So, what do I need to do?
The below sub-procedure isn't working like I expect it to. Basically, I have 9 fields on a tab control. When a user clicks in one of the fields, I wish for the field to "SelectAll" if their is a value already in the field. As you can see, the way I have it structured...only 1 field will do this, however, even this is not working.
Private Sub txtAddr1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtAddr1.Click, txtAddr2.Click, _
txtAddr3.Click, txtCity.Click, _
cmbState.Click, txtZip.Click, _
[code]....
The LINQ VB code below is to read the first record data for database table
ProductTable that has 3 colounms (or 3 fields):
TableCol1, TableCol2, TableCol3. The reading data is stored at variable
MyArrayFirstRow.
'-------start LINQ VB code in Visual Studio Web Developer 2008-------'
Dim MyArrayFirstRow
[Code].....
SQL Server has a Data Type of "Float". Visual Studio has a Data Type of "Decimal". In other words, if I have a variable in a VB.Net app that is defined as a "Decimal" ...can I move that value into a SQL Server Data Table column defined as a "Float"?
View 4 Replieshow to parse SQL Text with VB.NET?
Ex: I got a sql file "CREATE TABLE..." i want to get an array of columns and an array of data types.
Am trying to retrieve data from sql server based on two columns. Its a web application being developed using VS2010 (vb.net) but i keep getting the error: incorrect syntax near '='
Here's my code below:
Sub GetBasicMidwives()
' Set the SelectCommand properties...
With objDataAdapter
.SelectCommand = New SqlCommand()
[code].....
Is it possible to dynamically change the type of the object in a class?say, I have a Filter class, that specifies a filtering condition for a list of objects of a specific ObjType
Public Class PropertyFilter
Public Property ObjectType as MyObjectsTypeEnum
Public Property MainObjectProperty As ??? OBJECT
[code]......
When adding a column to a datatable. I can specify a type as one of my overloads such as
dt.Columns.Add(New DataColumn("UID", Type.GetType("System.Int32")))Why can't I use
dt.Columns.Add("etwe", TypeOf(Integer)) when I thought integer is a type. Instead its telling me that integer is a type and can't be used as an expression.
i need to bind two fields to an existing columns. but i dont know what to add on my for loop and on how to bind it to an existing column. see my code below.
[Code]...
I know you can dimention a variable and assign data to it at the same time using dim a() [1,2,3,4,5,6,7}but how can you do this with multiple arrays.is it something like [code]
View 4 RepliesI want to select column 'F1' from an excel spreadsheet and dump the data into my datatable 'oleDT'. How do I map the column F1 to the column i've added called 'colTest' ? When i call Fill, the dataTable has 2 columns, which are 'colTest' full of nulls and a created column called F1.[code]...
View 1 RepliesI'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
how to execute this SQL Statement
Scenario:
Given Tables T_Data, T_AllDesc, T_System1, T_System2
Given Fields:
T_Data= f_id, f_Desc, f_CreationDate, f_CreationTime, f_System1, f_System2
[Code].....
I have a function that writes value of dynamic textboxes (quantity & price) and their sum (value) into sql db, all in other column. Now there multiple entrys for the sam user (ID). Now I would like to know how can I get the sum of the value3 fields in the db to the vb.net form?
this is my code:
Dim kol As String = ""
Dim cena As String = ""
Dim znesek As String = ""
[Code]......
I need a list of all the SQL types and their .NET (vb would be preferred, but C# also works for me)equivalent.
View 3 RepliesRight now, inside the access file, the mssql tables are set up as linked tables so queries can be written using tables from both databases. (e.g. "select * db1.table1 where db1.table1.somevalue not in db2.table1", or select into tables like that one)These queries need to be moved into a VB.NET project, but still be linked to the access file.ng loops or something?
View 3 RepliesI am attaching DBs using following code.
Dim conn As New SqlConnection("Server=MyHomeServerSQLExpress;Database=master;Integrated Security=SSPI")
Dim cmd As New SqlCommand("", conn)
cmd.CommandText = "CREATE DATABASE dbNoPWD ON ( FILENAME = 'd:dbNoPWD.mdf' ), ( FILENAME = 'd:dbNoPWD_log.ldf' ) FOR ATTACH"
conn.Open()
cmd.ExecuteNonQuery()
cmd.Dispose()
conn.Dispose()
I do not want to give any username and password. When I ran the above code and then checked SSMS, I found my attach DB was not checked in Roles (pls. see pic.) The problem with this is my network computers can not access this DB. I want to run some code like above (without sa password) and want that all my network computers can access the DB without my user get involved in setting up SSMS.
In VB.NET I would like to create a complicated data structure with multiple types of data stored in an array like format (see below). I am trying to create a data structure that would look something like this: [Name; xLoc; yLoc; zLoc; [Jagged Array]] Note: Name needs to be dimensioned as a string, xLoc and so forth as integers. The Jagged Array would look like this:
[Code]...
I am required to send MS-Access table to SQL Server Database, based on fields Selected in Listview.
1)Till now i am able to get Access table names and their field in List view.
2)I am able to check whether database exists and Whether table exists in SQL Server with same name from VB.Net.Now i don't know how to insert Access Tables based in Fields Selected in ListView to SQL Server.
Basically what I want to do is, say after I've filled my datatable(whichever fill method i used[dataadapter.fill; or datatable.load(reader)]), now the datatable has the fields i've selected albeit, "Select * from" or "Select field1, field3 from" - either way the table now has my fields. Later incode when i'm ready to access them, say "dt.rows(x)(" OR "dt.rows(x)!", right here I would like intelisense to show me the available fields for that table. I already have my clsDataTable that inherits DataTable.
View 6 RepliesWhat I am trying tot achieve is the following:User inputs data in one form that saves to the dataset table no problems. On an edit screen I want the current data saved to appear in this page within all the relevant fields but when saving I want this data to add to the dataset table as an additional line of data so the transaction records are kept.I want to add a new datarow regardless of it saving one change or all 7 changes that are possble.
e.g. Line 1 - user inputs 7 cells of data Line 2 - user amends 2 cells of data Line 3 - user amends 1 cell of data an so on. Unfortunately the terminology for certain items above may not be correct as I am still new to this programming and still on a massive learning curve.At the moment I do not have the code for what I am trying to achieve as I really dont know where to start with it.I am currently able to save the data and have it appear in the "edit" panel however only the cells changed are saved an it overwirtes the initial input.
[code]...
I�d like to pass data from my VB 2008 project to data fields set in Word. Can it be done and if so
View 10 RepliesQuestion is the title itself. I was asked to use computed columns in SQL Server. But when I searched about it in Google, I found it was mainly for displaying the combined values of more than one coloumn. And usage of this may reduce performance if it is treated as a permanent coloumn. So I like to know
Advantages and disadvantages When and where we need to implement this. how can I achieve a solution for the below problem, if possible (with Compute columns. If not possible why?). Or any other way to implement this requirement. My requirement is to use a colomn which will identify which coloumn of that table was updated.So I can compare the values and identify the changes.
[Code]...
I have a combo box with a data source. This box shows one column of a table and allows me to select one item.Next, I have an ordinary text LABEL that I need to put text from another column of the item selected above.I tried to set the data binding field of the label, but this grabs only the first row or data and shows the selected column. That is nice, but I can not figure out how to update the selected selected ROW when the combo box item is changed.In this case the combo box lists a bunch of inventory parts. When I select a specific part, I need the change the text in a label to show the manufacturer. (like a sub-form). This same behavior will be used in several other places, but the relationships can cascade.
View 4 RepliesI want to add or update columns using alter table if i am adding a new column i want show rror. I am using the code belowalter table Personal_Details alter columns DOB datetimef i uncheck the NULL to not NULL then it will shows column does not allow nulls; update fails;i want to insert the fields in between columns not at end.
I am using this vb.net code file to call a procedure to get dates (among other things). When I execute this procedure in SQL 2005 Server Management Studio, I get about 10 columns. However when I execute this code, the dataset seems to only have one index value, maybe I am misunderstanding something. When I change this
ds.Tables(0).Rows.Count.ToString
to
ds.Tables(1).Rows.Count.ToString <---changing the index value to 1
(or higher)
I get no information. So my question is;
Does the DataSet contain the other columns, only not indexed like an array? What I want to do is choose which of the columns to filter out and turn the rest into JSON formatted strings.
Decimal type columns have Precision and Scale where the length of the integral part of the decimal would be Precision - Scale, if the Precision is 4 and the Scale is 2 then the integral part can only contain 2 digits (4-2). As such I will probably need a control that I could set how much it should accept on its integral part. In that regard I am not sure which control is best for such cases, I could try to make a usercontrol that will handle that but is there any other control out there that I could utilize for this purpose, intrinsic to .Net or a custom control out there? I could also just validate the data keyed-in but the above solution seem to be more user-friendly. Curiously, when databinding such Decimal type columns, how is it handled when the specified integral part exceeds the allowable size (Precision minus Scale)?
View 1 Replieshow can i insert data from data base with selected Datagridview columns i have insert combobox to Datagridview and it can load data from DB now i need insert data to another columns in Datagridview when i change combobox items?
View 7 Replies