error at javascript that connect to sql, asp.net c#

Question

I have javascript timer countdown with the code:

<script language="JavaScript">
TargetDate = "<% = TargetDate %>";
/*this is a property in code behind*/BackColor = "palegreen";
ForeColor = "navy";
CountActive = true;
CountStepper = -1;
LeadingZero = true;
DisplayFormat = "%%D%% Days, %%H%% Hours, %%M%% Minutes, %%S%% Seconds.";
FinishMessage = "the auction end"
</script>
<script language="JavaScript" src="countdown.js"></script>
</script>

the code behind:

public string TargetDate ()
{

    DataTable dataTable = new DataTable(); 
    using (SqlConnection connection = new SqlConnection("Server=localhost;Database=Timer;Trusted_Connectopn=True"))
    using (SqlCommand command = connection.CreateCommand())
    { 
        command.CommandText = "select * from endTime"; 
        connection.Open(); 
        SqlDataReader reader = command.ExecuteReader(); 
        dataTable.Load(reader); }
}

i get the error: 't.TargetDate()': not all code paths return value.

when i tried to write return i got another error... what means that i dont know what to do :)

Alex Aza · Accepted Answer · 2011-05-17 07:33:29Z

2

Your method supposed to return string. It doesn't.

public string TargetDate

There is no return.

Use ExecuteScalar, instead of ExecuteReader.

Return the string value.

answered May 17, 2011 at 7:33

Alex Aza

78.8k26 gold badges157 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tieson T. · Accepted Answer · 2011-05-17 07:37:52Z

0

You also have a spelling error in your connection string: Trusted_Connectopn should be Trusted_Connection

answered May 17, 2011 at 7:37

Tieson T.

21.2k6 gold badges82 silver badges99 bronze badges

Comments

AjayR · Accepted Answer · 2011-05-17 08:00:07Z

0

First of all you must return the targetdate value as string according to your function specification. You should read the datatable and return that. Something like this

public string TargetDate ()
{
    String tDate = "";
    DataTable dataTable = new DataTable(); 
    using (SqlConnection connection = new SqlConnection("Server=localhost;Database=Timer;Trusted_Connection=True"))
    using (SqlCommand command = connection.CreateCommand())
    { 
        command.CommandText = "select * from endTime"; 
        connection.Open(); 
        SqlDataReader reader = command.ExecuteReader(); 
        dataTable.Load(reader);
         tDate = dataTable.Rows[0][0].toString(); // Expecting the first row and first column
 }
return tDate;
}

Hope this helps.

edited May 17, 2011 at 8:00

answered May 17, 2011 at 7:40

AjayR

4,1894 gold badges49 silver badges81 bronze badges

2 Comments

Oshrib Over a year ago

thank you. i got error to the line: tDate = dataTable.rows[0][0]; // Expecting the first row and first column }return tDate;} the error: CS1061: 'System.Data.DataTable' does not contain a definition for 'rows' and no extension method 'rows' accepting a first argument of type 'System.Data.DataTable' could be found (are you missing a using directive or an assembly reference?)

Oshrib Over a year ago

thanks again. i editet the: tDate = dataTable.Rows[0][0].ToString(); now, there is other problem... at the aspx page, to the line: TargetDate = "<% = TargetDate %>"; the error: CS1502: The best overloaded method match for 'System.IO.TextWriter.Write(char)' has some invalid arguments..... char ?! ... oh what a code.. what now ? :) thank you !

Collectives™ on Stack Overflow

error at javascript that connect to sql, asp.net c#

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related