Asp.net - Input string was not in a correct format.

Today's techno world, people are making everyday silly mistack with coding.

Here I am trying to cover one simple error message "Input string was not in correct format".

Base on above error message experience developer know where he/she had make a mistack but I am writing this blog for newbie of Asp.Net, C# developer.

when you try to convert any empty string, double value etc into integer value. that time getting above message.

Lets check example.

var intValue1 = Convert.ToInt32("-52.066666"); // error

var intValue2 = Convert.ToInt32("52.066666"); // error

var intValue3 = Int32.Parse("52.066666");  // error

var intValue4 = Int32.Parse("52");  // Correct

var intValue1 = Convert.ToInt32("-52"); // Correct

Hope you getting basic idea for string conversion issue.

Read More

Covnvert List to String in C#

Sometime developer required convert List to comma separated string.

So here we just quick look of string.Join code magic and get our expected result.

List number = new List();
number.Add(1);
number.Add(4);
number.Add(50);
number.Add(78);

string strNumber = string.Join(",", number.ToArray());

Response.Write(strNumber);

Output: 1,4,50,78

Hope you enjoy it!!

Read More

Split function in sql server

Below function useful in sql server from split string.

create function dbo.Split(@String varchar(8000), @Delimiter char(1))
returns @temptable TABLE (id bigint identity(1,1),items varchar(8000))
as
begin
declare @idx int
declare @slice varchar(8000)

select @idx = 1
if len(@String)<1>

while @idx!= 0
begin
set @idx = charindex(@Delimiter,@String)
if @idx!=0
set @slice = left(@String,@idx - 1)
else
set @slice = @String

if(len(@slice)>0)
insert into @temptable(Items) values(@slice)

set @String = right(@String,len(@String) - @idx)
if len(@String) = 0 break
end
return
end


Example

select * from dbo.Split('abc efg', ' ')

OutPut
---------
abc
efg

Read More