.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

datatype convertion

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :Windows Application
 

I have created many stored procedure in sql server 2005 for handling insert,delete,update action. but i always encounter a datatype convertion probelm when i convert from string to other datatype before insert into database.

the probelm i am facing is

i have a textfield ID=txtName

1. when the txtName.text is empty or i haven't inputted anything,i can't set it to datarow of datatable

dt.rows[0]["name"]=txtName.Text.toString();

ERROR: string format was not a valid format. ( when the text field to string)

2. how can i check if the string text is a valid integer when i convert string to int, when i convert to datetime entercounter same probelm

int intID=int.parse(txtID.Text.toString());

ERROR: invalid format to convert to int or dateTime.

very upset, please help~




View Complete Post


More Related Resource Links

What is CultureInfo datatype?

  

Hi all members!

        whats  Cultureinfo datatype.Please help to know clearly..I ve seen more Sites but i can't able to understand guys!!

        Ex:("CultureInfo culture = new CultureInfo( "hi-IN" );")Embarassed


Store Null Data In image datatype in sql server 2005

  

hi

i wanted to store image in sqlserver database image field and i did. But now in some cases i want to store null value in that image field please let me know how to do this using file uploader.please give complete sample code.


regards


Query on XML datatype in SQL Server 2008

  
Hi All, In table I have column with XML datatype. I can able to read the below XML tag. SET   @Title = CAST(@XMLContent.query('data(root/chemicalName)') AS VARCHAR(50)) <root><chemicalName>Sulphuric acid</chemicalName></root> but how can I read (in SQL Server 2008) with multiple rows in it, and how to know the list of child nodes and data of it dynamically? <Root> <Row> < CurrencyCode>GBP</CurrencyCode> < CurrencyName>POUND (STERLING)</CurrencyName> </ Row> <Row> < CurrencyCode>INR</CurrencyCode> < CurrencyName>Rupee</CurrencyName> </ Row></

Transactional Publication With Article Using DATE Datatype Causes Snapshot Agent to Fail with Error

  
So I am using SQL Server 2008 Enterprise Edition (64Bit) and have run into a strange problem that is baffling me. I have two tables that I need to replicate.  They are identical in specification except the name (one is for monthly stats and one daily stats) CREATE TABLE [dbo].[statsDailyLite]( [EntryDate] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsDailyLite] PRIMARY KEY CLUSTERED ( [EntryDate] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO CREATE TABLE [dbo].[statsMonthlyLite]( [EntryMonth] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsMonthlyLite] PRIMARY KEY CLUSTERED ( [EntryMonth] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO They both conatin a thousand or so test rows of data, and they are both in a transactional publication going to another SQL 2008 box. Now when the tables are empty

Convertion failed when converting datetime to String

  
DECLARE @usr datetime SET @usr = user+'::Date' IF NOT EXISTS (SELECT 'X' FROM table WHERE Name = 'File' AND CONVERT(varchar,DateAdd, 101) = CONVERT(varchar, getdate(), 101)) BEGIN INSERT INTO table (Code, Name, Date) VALUES ('DD', 'File',@usr) END the date will be created by another process and its value will be loaded in the variable DATE. I'm calling that variable here. I;m getting the error Convertion failed when converting datetime to String. how to resolve this..??

Convertion failed when converting datetime to String

  
DECLARE @usr datetime SET @usr = user+'::Date' IF NOT EXISTS (SELECT 'X' FROM table WHERE Name = 'File' AND CONVERT(varchar,DateAdd, 101) = CONVERT(varchar, getdate(), 101)) BEGIN INSERT INTO table (Code, Name, Date) VALUES ('DD', 'File',@usr) END I;m getting the error Convertion failed when converting datetime to String. how to resolve this..??

Insert/Update OLE Attachment(Binary datatype) using SQL server 2000

  
Hi All, In the same senario how we can Insert/Update OLE Attachment(Binary datatype)  from one source table to other destination table by using SQL Server 2000 not with C# fronend code. Appreciated if you can give fix on this regads, Divakar.

How to sorting different datatype in CollectionView?

  
I have a treeview using HierarchicalDataTemplate with itemssource collectionview that includes A_collection and B_Collection it looks like: Root -  A   --  B   --  B   --  B -  A   --  B   --  B -  B -  B -  B I tried to sort the whole tree by B.Time property.  How can I only sort B.Time in collectionView which has A and B collections and keep A in previous order? Please advise, thanks.

Using equal operator in transact-SQL for ntext datatype column

  
Hi, I've a problem with using equal operator in transact-SQL for ntext datatype column. (SQL Server 2000) I'm using the following SQL command text. use NorthwindSelect * from Categorieswhere Description ='Seaweed and fish' If I use 'like' operator intead of '=' then the qurey retuns correct value. Any idea about this? Any help is appreciated. Regards, Julia

retrun dataType of filtered data using REST API ?

  
I know how to get filter data but unable to figure out return type Here is my Code if you can please correct me       ClientsItem item = (ServiceReference1.ClientsItem) client;     string cl = item.Title;     string url = @"http://sharepoint04/sites/Test/_vti_bin/listdata.svc/Projects$filter=Client eq ' " + cl + @"'" ; ServiceReference1.   TestDataContext cont = new ServiceReference1.TestDataContext(new Uri(url));

What can be the datatype for a column having records as weblinks?

  
Hi, i am trying to insert records in a column having records as weblinks but it gives me following error. --------------------- Msg 128, Level 15, State 1, Line 2 The name "www.yahoo.com" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. -------------------------------- NOTE : i have tried nvarchar(2083) but still giving me the same error. but if i try insert something like http://yahoo.com i get ERROR : incorrect syntax near 'http:'-   

The 'DataType' attribute is not declared bug of MS SQL RS still here

  
Greetings. I am getting repeated bugs with reporting services that is described here https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=405739&wa=wsignin1.0 In short words, BIDS is saving the report in the wrong format, adding attributes to the tags that dont belong to the schema, and you can no longer open the report with BIDS, you have to carve those attributes out with Notepad, only to find out that next time you're working on it, they come back! This is getting seriously annoying as i virually cannot close my BIDS anymore, each time i want to reopen my project i have to edit it in the notepad!  Threre are words about "microsoft knows about this issue and changed it to "Fixed (External)" but noone knows how to install the fix... Help please.

how to get datatype a column in sqlserver ?

  
hi all I want have datatype a field in sqlserver how to get it with (T-sql) thank you

filestream datatype

  
What is the difference between :enable filestream for  t-sql statement and  enable filestream for file i/o streaming access in sql 2008 when and how both feature works?

hierarchyid datatype in sql 2008

  
hi everyone, I wanted to know what exactly GetDescendent(null,null)method represent.what 2 parameters(null,null)takes it. How it works? Thank you

oracle clob datatype length more 32000

  
Hi Friends       i am using a microsoft enterprise library for oracle data base. we return an output value of clob datatype in oracle of character length more thant  32000.How to handle this type problems in C#.net.if the passing a varible of string ,it chara cter limit is 32000.if than 32000 ,how to handle this in enterprise library.  

Inserting an 'image' (datatype) value through SQl and C++

  
In the application I develop, the database table having a column of 'image' datatype. Now I want to insert the values into that table directly from my program, which is in VC++ 6.0, using a direct ExecuteQuery() of INSERT(due to performance considerations).
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend