Tracking Forums, Newsgroups, Maling Lists
Home Submit Tracker Forums
  Advanced Search


DataSource Controls :: How To Change A Table Column Data Type

I attempted to change a table columns data type and in the process caused a lot of issues. I had a date column in one of my tables and stupidly changed it from varchar to date. When I tried to run queries on it I keep getting the 'cant find column 3 error'. Now that tables structure is:


So column 4 is actually the date column. All other queries work for thistable. I then tried tochange it back and then copiedall data to a new table and now I am using the new table and converting thedates as needed but I am still getting the error.

SELECT * FROM postlinks WHERE >= CONVERT(datetime,CONVERT(varchar(10),GetDate(),112))

View 16 Replies (Posted: Jan 21, 2010 05:07 PM)

Sponsored Links:

Related Forum Messages For ASP.NET category:
DataSource Controls :: Excel To SQL Column Data Type Conversions?
I want to import a spreadsheet into SQL. The import/export wizard forces Column A to be a double. In Excel, the column is formatted as text. When I try to convert from double to text/varchar/nvarchar, the import process fails. Why can't I convert a number to text in SQL?

Posted: Feb 12, 2010 05:31 PM

View 3 Replies!   View Related
DataSource Controls :: How To Select A Column With The Latest Datetime Data Type
How do I select a column with the latest "datetime" data type, in Visual Web Developer 2008, ASP.NET 3.5 ?

In the config data source WHERE option my options are greater than cookie, control, etc... but I would like to select where the datetime is the latest in the table.

Posted: Jun 14, 2010 01:02 AM

View 5 Replies!   View Related
DataSource Controls :: Property Data Type In The C# Entity For The FileStream Column?
I am creating a table in SQL 2008 that contains a column of type FileStream so I can save files in it.

Can Entity Framework handle this?

What will be the property data type in the C# entity for the FileStream column?

Posted: Jul 27, 2009 01:44 AM

View 2 Replies!   View Related
DataSource Controls :: Database Table Gender Data Type
I have a dBA who designed a table with a gender field, which the value can only be M or F. He designed the gender field as binary(1).

Posted: May 10, 2010 01:22 PM

View 6 Replies!   View Related
DataSource Controls :: Set Or Reset A Boolean Column In A Data Table?
I have defined some binary bit columns in an SQL database table to indicate yes/no conditions, but I don't know how to set or reset them. I tried to use "profile.Volunteer = 0;" C# code in an event handler to reset a voluntary state for the Profile table of members, but what I got back was an error message that said, "Constant value '0' cannot be converted to a bool'. So, if a '0' cannot be used to reset a boolean value, what can be used?

Posted: Mar 20, 2010 11:06 PM

View 2 Replies!   View Related
DataSource Controls :: LINQ - Select Column In Data Table?
Mmy data table has four columns. How can I get only selected columns name?

Posted: Feb 09, 2010 06:30 AM

View 5 Replies!   View Related
DataSource Controls :: Accessing Specific Column In Database With Column ID With Table Adaptor
I'm currectly tryin to access a specific value in my database in a specific column. I'm tryin to use the primary key of the table to access the actual value in the row of that ID.

The current code:


Just iterates through the table and looking for any row with the boolean 'checkin' value is True, then it takes the 'id' value of that row and stores it into an array. Is there a way that I can access a another entry, and only that entry, in the table with the 'id' stored in the array?

Like if my data base contained and int, primarykey, `id` value, a boolean, `checkedin` value, and a `time` value, is there a way to access, lets say, the row with `id` equalling 3 and and the checkIn value from that row?

Posted: Jan 06, 2010 03:09 AM

View 2 Replies!   View Related
DataSource Controls :: How To Query A Table That Contains An XML Column And Bind The Data To A Gridview Object
I have tried to query a table with an xmlcolumn by using XQuery and I can't get the Select to work.

All my knowledge/understanding of the subject comes from this MSDN article:


so I am probably overlooking something minor:

I tried this query Select col1, Phone.Query('element CellPhone{I am not sure about what goes here} I tried {data('Phone/cellPhone}from aTable Where Phone.Exist('/Phone/cellPhone/text()[contains.,"412-8977"]') = 1 This syntax is definitely not fun.

Posted: Jun 21, 2010 09:05 PM

View 2 Replies!   View Related
DataSource Controls :: XML Type Column Update?
This is SQL Server 2008 database. I have a tables which has a XML datatype column, Is XML Document = true, and ScemaCollection = InternalAttributeCollection.This is my schema


This is my table


I inserted this:


Now, the xml column is nullable and is currently is null for the John Doe record. I tried this update:


I get this error: "XML Validation: Declaration not found for element 'InternalAttributes'. Location: /*:InternalAttributes[1]"

Posted: Jan 14, 2010 09:03 PM

View 1 Replies!   View Related
ADO.NET :: Using Enterprise Manager Data Access Code Block And Have A Table In Sql Server 2005 With A Column Type Of 'bigint'?
Im using enterprise Manager data access code block and have a table in sql server 2005 with a column type of 'bigint'

when querying against this table and adding in a parameter, there isnt a long datatype available, so is Int32 an equivalent ?


Posted: Aug 04, 2010 03:24 PM

View 1 Replies!   View Related
DataSource Controls :: Comapare The Value Of Column Of Datetime Type With The Server Date?
I am using the following query to comapare the value of column of datetime type with the server date

select * from Tbl_MyTable where DATEADD(day, DATEDIFF(day,0,[Date]),0)=DATEADD(day, DATEDIFF(day,0,getdate()),0)

but with this I am not getting any out put .

how to compare two dates if the above way is not accurate

Posted: Jan 09, 2010 10:06 AM

View 4 Replies!   View Related
Forms Data Controls :: Gridview Column Change / Replace A Column Data Field Valueto 'Not Applicable'?
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field valueto 'Not Applicable' if that column has got avalue of 2 in database.

Posted: Jan 06, 2011 10:44 AM

View 2 Replies!   View Related
DataSource Controls :: Change SelectParameter To Accept Datetime Sql Type?
If I ran my sproc from query analyzer, I get the correct results(data is filtered by datetime), i.e:

exec Uds.Dashboard_GetJobs '9/20/2010 11:01:23 PM'

However, if I ran it from the Asp.Net page, (ALL records are showed). Looking at the SQL Profiler I see the following call:

exec sp_executesql N'exec Uds.Dashboard_GetJobs',N'@date nvarchar(21)',@date=N'9/20/2010 11:01:23 PM'

Running both statements above in the query analyzer it WILL return me different results. Why? Someone mentioned that it looks like I don't have correct data type specified for SQLParameter in .Net application. I was asked to create something like:

cmd.Parameters.Add("@Date",SqlDbType.DateTime).Value =

Well, my code in the is in this form:

<asp:SqlDataSource ID="sourceRealtimeLogging" runat="server"
ConnectionString="<%$ ConnectionStrings:UctConnectionString %>"
SelectCommand="exec Uds.Dashboard_GetJobs">
<asp:ControlParameter ControlID="UpdatedTimeUTC" Name="date" PropertyName="Text" />

So I guessI am passing a string to SQL, not a datetime type. How do I fix this? Not even sure if this is the cause of my issue but worth a try.

Posted: Sep 21, 2010 03:15 PM

View 3 Replies!   View Related
DataSource Controls :: SqlBulkCopy - String To Type Decimal In Target Column Error?
Iread a CSV file into aDataTable.TheDataTable in the first imageshows each column and type.The types are exactly what they are supposed to be and the data loaded all the rows it was supposed to load.From the second screen shot you can see the database table.SqlBulkCopy is supposed to map column names to database columns bydefault.According to that logic each column matches up exactly to the database and thecolumn types also match.However,when I run the command iterrors on the firstrow with:

"The given value of type String from the data source cannot be converted to type decimal of the specified target column."

Here is the StackTrace:

"at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount) at


Anyone have any ideas why this will not import correctly?

Posted: Mar 26, 2010 06:26 PM

View 4 Replies!   View Related
SQL Server :: How To Copy One Column Data From A Table To Another Table Column With Rest Of The Column
I want to copydata froma table[tblExcel][No.of columns:2]to another table[ev_event] which has5 columns, 2 columns from the another table, 3 columns from user defined value


Posted: Jan 16, 2011 12:51 PM

View 4 Replies!   View Related
DataSource Controls :: How To Get Column Name From A Table
I know there is a way to get all the column name from a table, but that is not what I want

I want to get only a few column name from the table, is there a way to do this?

Let say, table A has three columns that is A1, A2 and A3, I only want A1 and A2 column names, again, can this be done?

BY the way, I am using SQL Server 2005 with application.

Posted: Jan 14, 2010 08:16 AM

View 4 Replies!   View Related
DataSource Controls :: Change The Datatype Of A Column In Datatable?
I have a datatable which has a column named " DataValue" of type string. This table contains records. Now I want to change the datatype of this column from string to int.

but I am getting an Error .."Cannot change DataType of a column once it has data. "

How do I fix this Error.

Posted: Jul 02, 2007 07:13 AM

View 10 Replies!   View Related
DataSource Controls :: Column Does Not Belong To Table?
However has anyone ever seen a situation where, when you try to access the value of a column in a DataRow, you get the error "Column... does not belong to table.." when, in fact, it does?

The column name in question is called "ByWeight". I am wondering if either that, or maybe one of my other column names, is a reserved keyword and that's causing/masking this error.

If I look in the locals window and expand the DataRow, one of my columns is DBNull - by that I don't mean that the column value is DBNull, I mean the actual column itself is DBNull so it doesn't expand. I think there's a clue there.

Posted: Jun 24, 2010 10:02 AM

View 1 Replies!   View Related
DataSource Controls :: Conversion Of A Varchar Data Type To A Datetime Data Type Resulted In An Out-of-range Value?
Have updated from SQL 2005 to SQL 2008. When I enter date as 18/11/2009 get error message but 1/11/2009 is ok

Here is the code

VarDate = VarYear +"/" + VarMonth +
"/" + VarDay;
System.DateTime ReportedDate =

Posted: Nov 17, 2009 10:51 PM

View 2 Replies!   View Related
WebMatrix :: Does Not Change Column Type From Nvarchar To Ntext
Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.

Posted: Aug 20, 2010 03:16 PM

View 1 Replies!   View Related
How To Change A Column Of Char Type To Checkbox In Datagridview
How to change a column of char type to checkbox in datagridview.

Posted: Dec 15, 2008 06:33 AM

View 1 Replies!   View Related
DataSource Controls :: Saving Dataset Into A Column Of The Table?
I am developing a customized-able business report wizard.

I would like to save the report that i have been generated from the database and save in into the database.

Plan A - 1 of method that i am thinking of, which is capture the data generated from every wizard, update the dataset, the dataset will carry as a session, serialize it and save it into the column of the table.

By the time user would like to view the save-able report. It can easily load the table column, deserialize the column data into dataset and display the report.

How can i save the dataset into the column of the table ?

Posted: Dec 29, 2009 12:52 AM

View 3 Replies!   View Related
DataSource Controls :: Can Get A Single Column Of Rows In A Table
I have a tblClientGuests tableand in it are theFrist and Last names of guests attending a meeting for each of our clients. I need to return in a select statementa single column with the first and last name of all guests for each client_id.

So I would have a single row for each client_ID, like client _ID (1) and in it would be a column named(Guest) in the guest column would beall the names of that clients guests.

Maybe something like:

SELECT Guest FROM tblClientGuests WHEREClient_ID=1
Jim Smith, Jane Smith, Jack Jones, Debbie Philps

But thisis all in the one cloumn Guests

How could I do something like this?

Posted: Dec 07, 2009 06:56 PM

View 6 Replies!   View Related
DataSource Controls :: Add A New Column To An Existing Database Table!?
I have a table with several columns i created,

How can i add a new column and specify its data type now? i using sql server and Gridview.

I tried to add one using GridView but it shows me columns called edit delete something is not like my bound fields i created early.

Posted: Jan 13, 2010 01:43 AM

View 1 Replies!   View Related
DataSource Controls :: Access Time In A Column Of A Table?
I am able to store the current time of day in a column defined as time with the C# code as:notestable.NoteTime = DateTime.Now.TimeOfDay;The hour, minutes, seconds, and even millionth of a second is stored. But now, I need to retrieve the time and convert it into a string. I tried to use DateTime statements to accomplish this as with:

DateTime nt = notestable.NoteTime;
String FirstT = nt.Hour.ToString() + ":" + nt.Minute.ToString().PadLeft(2, '0');

Regarding the 'nt' variable, I got an error message that said: Cannot implicitly convert type 'System.TimeSpan?' to 'System.DateTime'.Regarding the 'Hour' designation, I changed the definition of 'nt' to 'var' and got an error message that said: System.Nullible<System.TimeSpan>' does not contain a definition for 'Hour' and no extension method could be found.So, how do I access the time from a table and convert it into a string for display in a TextBox?

Posted: Jun 25, 2010 09:45 AM

View 4 Replies!   View Related
DataSource Controls :: Insert/Update Sp Using User-define Table Type?
I use a sp to insert/update records. Parsing a DataTable (many) to a user-define table typesTable type:


Table to Insert/Update:


Will this work (snipp from sp)


Posted: Jul 02, 2010 02:50 AM

View 6 Replies!   View Related
DataSource Controls :: Alter Script To Change The Primarykey Column Datatype?
I am using SQL SERVER 2008 database. I have a table Customers in which the CustomerID column is had datatype INT intially but due to increase in Customers the number range is exceeding which may cause errorarithmetic overflow of data. Hence I thought to modify the datatype from INT to BIGINT and wrote an alter script but when I ran the script it failed. Hence provide me in creating alter script for the updating the datatype of the primarykey column for the Customers table.

Posted: Feb 22, 2010 10:03 AM

View 2 Replies!   View Related
DataSource Controls :: The Given Value Of Type String From The Data Source Cannot Be Converted To Type Datetime
I have this error "The given value of type String from the data source cannot be converted to type datetime of the specified target column." when I used sqlbulkcopy to do the transaction

Here is my code:


Posted: May 19, 2010 07:35 AM

View 3 Replies!   View Related
DataSource Controls :: How To Pass Null Value Into Varbinary(max) Column N To By Table
i want to pass null value into varbinary(max) column n to by table

if i do like this i have this function in my app_code .vb class

Public Function Remove_Attachment(ByVal Id As Integer) As Integer
Dim db As New dbAccess
db.commandText = "SP_RemoveAtt_DML"
db.commandType = CommandType.StoredProcedure
db.addParameter("@InOutVal_Id", Id)
db.addParameter("@Document", System.Data.SqlTypes.SqlBinary.Null.Value)
Catch ex As Exception
Throw ex
End Try
End Function

i got this error. Data is Null. This method or property cannot be called on Null values.

Posted: Feb 14, 2010 07:08 AM

View 4 Replies!   View Related
DataSource Controls :: How To Get Query To Return Values From Xml Column In Table
I am trying to do a lookup in a table with a value stored in an xml column.

I tried this several ways but I can't get it to work.

Here is some code:


Posted: Jun 24, 2010 09:56 PM

View 1 Replies!   View Related
DataSource Controls :: SQL Server - Subtract Column In Two Rows In Same Table
Looking for a way to subtract a column in 1 row from the same column in a prior row, where prior is defined by row InsertDateTime, for a given parent ID....

ID Value Date
1 10 1/1/09
1 15 1/3/09
1 23 1/4/09

So I want the difference in the Value column for row 1/4/09 - 1/3/09 = 8 and then from 1/3/09 - 1/1/09 = 5. So far I've got a join that joins the table onto itself where Date > Date, but I only want it to join to the next less date row, not all the next less date rows (i.e. only the Prior row only).

Posted: Dec 07, 2009 06:29 AM

View 4 Replies!   View Related
DataSource Controls :: Update Table Where Column Name Is Selected Dynamically C# / VB.NET
I want to Update Column of a Table where ColumnName will be DropDown.SelectedValue. Example: A set of RECORDS will be displayed from a Customer Table where CUstNo ='1234' and City= 'Chicago' and Grade ='B' Once displayed I want to Update the grade to 'A' of all those customers from the above criteria. In My case I have like 100 Columns, so in where Clause Column Names will be selected from a DropDown. In My Query, Update Customer SET ColumnName= 'some value' where ColumnName ='ActualValue' So how can I pass the ColumnName which is Dropdown Selected Value. I believe I can't give as Update Customer SET DropDown.SelectedValue = 'some value' where DropDown.SelectedValue ='ActualValue' how can I resolve this ?...

Posted: Mar 10, 2010 09:12 PM

View 9 Replies!   View Related
DataSource Controls :: Update Column With Null Value Using Table Adapter
I'm using a table adapter to update a record with a string and a null value. The database (sql server 2000) is set to allow nulls, the xml for paramter "AllowDbNull" is set to true, and my parameter called nullValue was created like this: Dim nullValue As Object = DBNull.Value

Here is my code:

Protected Sub checkInButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles checkInButton.Click

Posted: Nov 19, 2009 07:55 PM

View 3 Replies!   View Related
DataSource Controls :: Modifying Sql Server Table Column According To Pattern?
I have a phone number column in my table. I want to replace all parathenthesis by "( " or " )" ( give spaces after opening paranthesis and before closing parenthesis )

Posted: Dec 09, 2009 04:02 PM

View 1 Replies!   View Related
DataSource Controls :: Find Numeric Column Length Of A Sql Table?
i am trying to find thecolumn length of a particular sql table, it is workingvery fineif its 'nvarchar' or 'text' type. But if i try to get the numeric(int/bigint/bit) data type i am getting error. please help me out. The sample code is given below for you reference,'*** Source Code Start

Dim da
New OleDbDataAdapter(strQuery, PortalConn)


Posted: Feb 24, 2010 04:45 AM

View 5 Replies!   View Related
DataSource Controls :: Lookup Type Command To Select A Single Value From An Sqlserver Table?
I'm using vwd 2008 express

I need to display a single field from an sqlserver table, do I need to use sqlDataSource ect. or is there a simpler way (like msaccess's LookUp) for single values.

Posted: Apr 10, 2010 12:13 AM

View 1 Replies!   View Related
DataSource Controls :: New Table In Type Dataset Returns Get_ Method Not Found?
I added a new table to my type dataset. When the code tries to execute the new row on that table I get the error message.

(if you can't see the error. "MissingMethodException was caught" "Method not found: 'MyTableDataTable MyNamespace.get_SSCase().")

I've tried the wizard and also click and drag the table from solution explorer to the xsd file. The other tables work, just this one table won't work. What should I check?

Posted: Jul 01, 2010 07:17 PM

View 1 Replies!   View Related
DataSource Controls :: How To Convert Varchar Data Type Into Datetime Data Type
i have stored date as varchar(30) data type and Date format is dd/MM/yyyy now i have to convert it into datatime data type.

i have 330 records and each recod contain the Date in format of dd/MM/YYYY but due to varchar data type i can not perform calculation on Date so i have to convert into datetime without data lose.

Posted: Nov 02, 2008 05:17 AM

View 9 Replies!   View Related
DataSource Controls :: Unable To Change The Structure Of Table?
I have one table in database in which millions or records exest already. I can't change the structure of table. And i have to create 4 store procedure each of them will fetch 100 records from this table. And they will keep going on. But condition is that they should not fetch same row. how can all store procedure fetch uniqe data from table.

Posted: May 14, 2010 08:05 AM

View 4 Replies!   View Related
Copyright 2005-08, All rights reserved