ASP.NET

amit sahu2016-Dec-08 19:27

amit sahu20

16-Dec-08 19:27

DateTime? arivalDate = null;
DateTime? departDate = null;
fun(arivalDate,departDate)

public void fun(object Date_Start,object Date_End)
{
 if (Date_Start == null)
{            cmd.Parameters.AddWithValue("@Date_Start",System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
cmd.Parameters.AddWithValue("@Date_Start", Date_Start);
}
if(Date_End == null )
{
cmd.Parameters.AddWithValue("@Date_End", System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
cmd.Parameters.AddWithValue("@Date_End", Date_End);       
}
}

Christian Graus16-Dec-08 19:39

16-Dec-08 19:39

amit sahu20 wrote:
public void fun(object Date_Start,object Date_End)

This is ridiculous. Why pass an object and not a DateTime? ? Then you can use .HasValue, and generally write nice code.

Have you set a breakpoint to see which code executes ? Have you tried DbNull.Value ? I wonder if SqlDateTime is a type for SQL Server only ?

Christian Graus

Driven to the arms of OSX by Vista.

Rahul Gharat16-Dec-08 19:58

16-Dec-08 19:58

i did what u said

if (Date_Start == null){
cmd.Parameters.AddWithValue("@Date_Start",System.Data.SqlTypes.SqlDateTime.Null);
}

but i am geting error
System.Data.SqlClient.SqlException: Error converting data type nvarchar to datetime

with regards
rahul

Rahul Gharat16-Dec-08 19:32

16-Dec-08 19:32

i am doing this

DateTime CompletionDate;
if (txtCompletionDate.Text != "")
{
CompletionDate = Convert.ToDateTime(txtCompletionDate.Text);
}
else
{
CompletionDate = null;
}

and passing this CompletionDate to Store procedure

but i am getting error
cannot convert null to datetime

with regards
rahul

amit sahu2016-Dec-08 19:36

amit sahu20

16-Dec-08 19:36

use it before pass to DB
if (CompletionDate == null)
{ cmd.Parameters.AddWithValue("@CompletionDate",System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
cmd.Parameters.AddWithValue("@CompletionDate", CompletionDate);
}

and also in DB "CompletionDate" field shulid allow null

Christian Graus16-Dec-08 19:41

16-Dec-08 19:41

Oh, you were answering, not asking. The code you posted is still messy, even if SqlDateTime.Null works.

Christian Graus

Driven to the arms of OSX by Vista.

Rahul Gharat16-Dec-08 20:09

16-Dec-08 20:09

in DB completiondate allows null

but it still gives same error

with regards
rahul

Christian Graus16-Dec-08 23:06

16-Dec-08 23:06

How do you know it allows null ? In any case, your error is not that null is not allowed, but that the date object is broken. I think you need to make your code typesafe, walk through with the debugger and see what date is passed in. You also need to fix your code where it is prone to breaking.

Christian Graus

Driven to the arms of OSX by Vista.

Christian Graus16-Dec-08 19:40

16-Dec-08 19:40

This is messy. What if the text entered cannot be converted ? This code is fragile and not production quality, on many levels.

I need to see the code that throws that error, in order to comment on it.

Christian Graus

Driven to the arms of OSX by Vista.

Rahul Gharat16-Dec-08 20:07

16-Dec-08 20:07

DateTime? StatusDate,CompletionDate;

if (txtStatusDate.Text != "")
{
StatusDate = obj.ConvertStringToDate(txtStatusDate.Text);
}
else
{
StatusDate = null;
}

i am get error in below code
public Boolean InsertTask(string oprtype, object StatusDate)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlcommand = "DailyReport";
DbCommand dbcommand = db.GetStoredProcCommand(sqlcommand);
db.AddInParameter(dbcommand, "@oprtype", System.Data.DbType.String, oprtype);
if (StatusDate != null)
{
db.AddInParameter(dbcommand, "@StatusDate", System.Data.DbType.DateTime, StatusDate);
}
else
{
db.AddInParameter(dbcommand, "@StatusDate", System.Data.DbType.DateTime, DBNull.Value);
}
db.ExecuteNonQuery(dbcommand);
return true;
}

with regards
rahul

Christian Graus16-Dec-08 23:04

16-Dec-08 23:04

rahul.gharat wrote:
object StatusDate)

Why are you still passing this as an object ? In any case, if this is passing DBNull.Value, and the procedure fails, then your database doesn't support null. That's really about it. Have you tried running the proc directly against the database ? What does the proc look like ?

I can't help but feel that if you made this code typesafe, it might well work. You're not passing a datetime, you're passing an INullable<DateTime> and I can't help but wonder if that makes a difference, when all you tell the compiler is that it's an object.

Christian Graus

Driven to the arms of OSX by Vista.

Website Deployment

kirandilip16-Dec-08 18:34

kirandilip

16-Dec-08 18:34

good morning every one,
i generated a website application using asp.net with c#.net.i want to deploy that website but i donot know how to deploy the website,plz tell me how to deploy the website by a step by step procedure.
thanks in advance.

Christian Graus16-Dec-08 18:48

16-Dec-08 18:48

Copy the files onto the server. Make sure the server has ASP.NET installed. Point IIS to your site.

Christian Graus

Driven to the arms of OSX by Vista.

Abhijit Jana16-Dec-08 18:53

Abhijit Jana

16-Dec-08 18:53

Just 2 day back there was a same Question on CP.
Check [^]
You can find step by step description over there.
-------------
This is one of the common question that i have faced in this forum. So I have planned for write a step by step guide to deploy the sites. Hope I will upload it in CP as early as possible Wink | ;)

cheers,
Abhijit
My Recent Article : Beginner's Guide to ASP.NET Application Folder

Vimalsoft(Pty) Ltd16-Dec-08 19:18

Vimalsoft(Pty) Ltd

16-Dec-08 19:18

Step1:Make sure that the IIS is Installed,

Step2: Make sure that the Correct .NET Framework for your Application is Installed

Step 3: Create an Virtual Directory

Step 4: Copy your Files in the Vurtual Directory

And thats it Smile | :)

Simple ne

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Christian Graus16-Dec-08 19:43

16-Dec-08 19:43

And you repeated the advice already given because.,..... ? These repeat answers flood the forums, an easy question sometimes gets 8 answers, all of them the same.

Christian Graus

Driven to the arms of OSX by Vista.

Vimalsoft(Pty) Ltd16-Dec-08 19:47

Vimalsoft(Pty) Ltd

16-Dec-08 19:47

Sorry about that

how make a move next command??

Brij16-Dec-08 19:34

Brij

16-Dec-08 19:34

chaeck the links
[^]"> [^]">

Cheers!!
Brij

meki_211816-Dec-08 18:27

16-Dec-08 18:27

Hi, How can I create a move next command in web development???

Dim DS As New DataSet

TextBox1.Text = DS.Tables(0).Rows(DS.Tables(0).Rows.Count() + 1).Item("ITEM_NAME")

This code that I've used just give a move last command and i can't figure out how to the move next so that I can look for the items in my data base one-by-one.

can you give me some solution?

Thanks a lot in advance.

Brij16-Dec-08 18:44

Brij

16-Dec-08 18:44

do you want to show the ITEM_NAME one by one in textbox?

Cheers!!
Brij

meki_211816-Dec-08 19:02

16-Dec-08 19:02

yes, that's what I'm trying to do. But the code that I've used only showed me the last item in my query.

Brij16-Dec-08 19:29

Brij

16-Dec-08 19:29

You can do onething
Start from 0,increment it and save it in viewstate then next commond take the value from viewstate and show it again same way increment and save it viewstate .Do the same till last element.And show the value like below

TextBox1.Text = DS.Tables(0).Rows(int.Parse(viewstate["counter"])).Item("ITEM_NAME")

Cheers!!
Brij

meki_211816-Dec-08 20:00

16-Dec-08 20:00

Brij wrote:
TextBox1.Text = DS.Tables(0).Rows(int.Parse(viewstate["counter"])).Item("ITEM_NAME")

I've tried your code but there are some errors. The "int" can't be loaded and there's a identifier need in the ["counter"] part. Frown | :(

Nishant Singh16-Dec-08 19:04

Nishant Singh

16-Dec-08 19:04

Keep a Global Variable
and increment it's value when u click on MoveNext
Global Variable intGlobalCount

TextBox1.Text = DS.Tables(0).Rows(intGlobalCount ).Item("ITEM_NAME")

meki_211816-Dec-08 19:12