ASP.NET

Re: Populating Sybase database date in three drop downlist

13-Feb-09 21:04

Hi i am praneeth, i am able to bring the date in a string ,but having problem in splitting and populate in dropdownlist's, please help me ,thank's in advance.

my code which i have tried,

private void GetCurentDay()
{
OdbcCommand cmd = new OdbcCommand("select convert(date,getutcdate())", conn);
OdbcDataAdapter ad = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
try
{
conn.Open();
cmd.ExecuteNonQuery();
ad.Fill(ds, "date");
if (ds.Tables[0].Rows.Count > 0)
{
currdate = ds.ToString();
ddlFromDay.Items.Add(currdate);
}
}
catch { }
finally
{
conn.Close();
}
}

ABitSmart13-Feb-09 21:19

Re: Populating Sybase database date in three drop downlist

13-Feb-09 21:19

Praneeth Babu K wrote:
having problem in splitting and populate in dropdownlist's, please help me ,thank's in advance.

what and how are you trying to split ?

Praneeth Babu K13-Feb-09 21:41

Re: Populating Sybase database date in three drop downlist

13-Feb-09 21:41

string currdate is populating date as 2/14/2009 , i want to populate it in 3 different dropdownlist , like ddldfromday ,month and year.

Abhijit Jana13-Feb-09 21:49

Abhijit Jana

13-Feb-09 21:49

Praneeth Babu K wrote:
string currdate is populating date as 2/14/2009 , i want to populate it in 3 different dropdownlist , like ddldfromday ,month and year.

So, You want to split 2/14/2009 in Day, Month and Year?
if yes the

string strcurrentDate="2/14/2009"
string [] Difdate=strcurrentDate.Split('/');

now, you can add day, month, year in different Dropdown list , Like

ddldfrom.items.add(difDate[0].ToString());

cheers,
Abhijit
CodeProject MVP

Re: Populating Sybase database date in three drop downlist

Praneeth Babu K13-Feb-09 22:05

Re: Populating Sybase database date in three drop downlist

13-Feb-09 22:05

sorry yaar for repeatedly asking ,when i try like this i am getting in dropdownlist as system.data.dataset

OdbcCommand cmd = new OdbcCommand("select convert(date,getutcdate())", conn);
OdbcDataAdapter ad = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
try
{
conn.Open();
cmd.ExecuteNonQuery();
ad.Fill(ds, "date");
if (ds.Tables[0].Rows.Count > 0)
{
currdate = ds.ToString();
string[] temp = currdate.Split(new char[] { '/' });
ddlFromDay.Items.Add(temp[0].ToString());

}
}
catch { }
finally
{
conn.Close();
}

Abhijit Jana13-Feb-09 22:10

Abhijit Jana

13-Feb-09 22:10

Praneeth Babu K wrote:
conn.Open();
cmd.ExecuteNonQuery();
ad.Fill(ds, "date");
if (ds.Tables[0].Rows.Count > 0)
{
currdate = ds.ToString();
string[] temp = currdate.Split(new char[] { '/' });
ddlFromDay.Items.Add(temp[0].ToString());

}

Did you Debug your Code ?

Praneeth Babu K wrote:
currdate = ds.ToString();

What is value of currdate?

cheers,
Abhijit
CodeProject MVP

Re: Populating Sybase database date in three drop downlist

Praneeth Babu K13-Feb-09 22:31

Re: Populating Sybase database date in three drop downlist

13-Feb-09 22:31

currdate value is 2/14/2009 12:00:00 AM

Abhijit Jana13-Feb-09 22:56

Abhijit Jana

13-Feb-09 22:56

Praneeth Babu K wrote:
currdate value is 2/14/2009 12:00:00 AM

It's is coming after changing the code.

Praneeth Babu K wrote:
currdate= ds.Tostring();

The value you have given is not from this line of code. I believe you have got your mistake.

Now, How to get the same result that we have already told you from this currdate, it now your home work. Try to resolve it yourself.

cheers,
Abhijit
CodeProject MVP

Re: Populating Sybase database date in three drop downlist

ABitSmart13-Feb-09 21:50

Re: Populating Sybase database date in three drop downlist

13-Feb-09 21:50

If currdate is a string you can split it (and has the value in format '2/14/2009')

string []temp = currdate .Split(new char[]{'/'} );

temp will contain the separated values.
if currdate is a datetime variable then currentdate.Day, currentdate.Month, currentdate.Year will give you the values.

you will need to add the values to each of the lists.

Praneeth Babu K13-Feb-09 22:06

Re: Populating Sybase database date in three drop downlist

13-Feb-09 22:06

ABitSmart13-Feb-09 22:10

Re: Populating Sybase database date in three drop downlist

13-Feb-09 22:10

Praneeth Babu K wrote:
ds.ToString();

That is the problem.
You need to read value of the column containing the DateTime value and not the dataset.

Praneeth Babu K15-Feb-09 18:02

15-Feb-09 18:02

thank's guys for helping i got this,this is working code

private void GetCurentDay()
{
OdbcCommand cmd = new OdbcCommand("select convert(date,getutcdate()) as getdt", conn);
OdbcDataAdapter ad = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();

string CurrDate;

try
{
conn.Open();
cmd.ExecuteNonQuery();
ad.Fill(ds, "date");
if (ds.Tables[0].Rows.Count > 0)
{
CurrDate = ds.Tables[0].Rows[0]["getdt"].ToString();
string[] strarray;
strarray=CurrDate.Split('/');
// Response.Write(strarray[0]);
ddlFromMonth.Items.Add(strarray[0]);
ddlFromDay.Items.Add(strarray[1]);
ddlFromYear.Items.Add(strarray[2].Substring(0,4));
}
}
catch
{
}
finally
{
conn.Close();
}
}

Windows Service

sjs4u13-Feb-09 19:21

sjs4u

13-Feb-09 19:21

Hi,

I have written window service. Now I insert record using windows service and it's working fine. I want to execute URL with the help of window service. For testing purpose I written a code to execute URL in windows form. It's working fine. but when I write code for execute URL in window service and place it at serive then it showing me error.

Is window service not supported to URL execute code?

Is there any other solution for that?

Thanks
sjs

Christian Graus13-Feb-09 22:34

Christian Graus

13-Feb-09 22:34

What you're doing makes no sense at all. Why do you need to use a service in an ASP.NET app ?

Christian Graus

Driven to the arms of OSX by Vista.

sjs4u13-Feb-09 23:20

sjs4u

13-Feb-09 23:20

Then You tell me what can I do.
Should I write Webservice? or any other solution.

Thanks
sjs

Scott Dorman14-Feb-09 15:31

Scott Dorman

14-Feb-09 15:31

You need to explain what you are trying to accomplish before anyone can actually give you an answer of how to approach it.

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Re: Gridview Event Problem

Christian Graus14-Feb-09 22:47

Christian Graus

14-Feb-09 22:47

Sounds like you have not the slightest idea of what you are doing. Instead of building whatever you last read about on the toilet, try understanding the different technologies and building what's suitable for your needs. If this is a paid project, and you're the one taking the job, tell the client you are stealing from them. If it's your job, talk to your boss. If it's homework, talk to your teacher. If you're doing it for fun, then try to start slower, and to learn as you go so you understand what the bits you're using are for,

Christian Graus

Driven to the arms of OSX by Vista.

Frame

ellllllllie13-Feb-09 19:01

ellllllllie

13-Feb-09 19:01

Hello,

Can anybody get me the exact role of the Frame.send() method

best regards.

dghdfghdfghdfghdgh

Gridview Event Problem

ais0713-Feb-09 18:25

ais07

13-Feb-09 18:25

Hi There,
I am facing a unique problem.I had taken a check box in a gridview.And I want to fire Checked Change Event Of Checkbox.But It didn't get fired.If I open any previous project from my backup then it get fired.But in my this project I am not able to fire this event.Whats the problem with the project.If I take that page in another project and try to fire the event then also it didn't get fired.Even if I copy any control from this page then also it didn't get fired.But if I take a fresh project with new controls then that event get fired.Can anyone tell me what is the problem.

Thanks.

Calin Tatar14-Feb-09 14:15

Calin Tatar

14-Feb-09 14:15

Did you set AutoPostBack property to true?

Calin

How to avoid Videos being cached [modified]

.NET- India 13-Feb-09 17:49

.NET- India

13-Feb-09 17:49

Hello Friends,

I've a gridview in that gridview i've taken a commmand named "Play" for playing different-different songs and songs name are also unique. Its working fine in the browser "Flock" and caching those videos in Internet Explorer. Can anybody suggest me the way

here i'm giving the link where i've uploaded it.

http://www.saamstesting.com/Admin/VideoUpload.aspx[^]

modified on Saturday, February 14, 2009 12:23 AM

Re: How to avoid Videos being cached

ABitSmart13-Feb-09 21:17