|
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();
}
|
|
|
|
|
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
|
|
|
|
|
currdate value is 2/14/2009 12:00:00 AM
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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();
}
|
|
|
|
|
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.
|
|
|
|
|
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();
}
}
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Then You tell me what can I do.
Should I write Webservice? or any other solution.
Thanks
sjs
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Hello,
Can anybody get me the exact role of the Frame.send() method
best regards.
dghdfghdfghdfghdgh
|
|
|
|
|
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.
|
|
|
|
|
Did you set AutoPostBack property to true?
Calin
|
|
|
|
|
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
|
|
|
|
|
did you try disabling caching ??
1[^]
2[^]
3[^]
|
|
|
|
|
I've already done it. But it's still doing that.........
modified on Saturday, February 14, 2009 3:41 AM
|
|
|
|
|
Hi,
I have a UpdatePanel with a div.
<updatepanel id="UpdatePanel1" runat="server">
<contenttemplate>>
aaaaa
In the server side I change the content of the testDiv on every asynchronous postback. And when the updatepanel gets updated, I want to fire a javascript event. This is what I do
function pageLoad() {
$addHandlers($get('testDiv'),
{ 'DOMAttrModified' : test,
'propertychange' : test});
}
function test(eventName)
{
alert('Success');
}
This seems to work in ie but fails in firefox. The event DOMAttrModified never gets fired. Please advise. Here is a link that might help
http://www.chrisrauber.com/blog/CommentView,guid,5674c491-eb0e-46dc-80ef-c87fbe606759.aspx[^]
|
|
|
|
|
its strange. the link mentions that DOMAttrModified is not supported in IE and should work well in firefox. read this [^]
|
|
|
|
|
Thanks for the response.
Well DOMAttrModified works if I use it in a normal way. But when it comes to updatepanel it does not work. In an asynchronous postback, the innerHTML property of the UpdatePanel is replaced with the new html from the server, so DOMAttrModified event should get fired. The onpropertychange of ie does get fired in this case.
|
|
|
|
|
hi
i have the following scenario:
each employee authorized to just enter some pages in web site, as an example : jack can enter page 1 ,2 and 3 ,mary can enter page 1 and 3;
i want each employee to see a treeview that show him/her the pages that can enter;
what is the best way to implement this dynamic view, i mean, i want each employee when enter to see a treeview with pages that can access and i need to keep this tree view alife while he is logging on.
HINT: i am not using neither membership nor roles in my web site, i have my own database to store users and to store pages which they can access
is there any useful tutorial in this domain
thank you
|
|
|
|
|
If there is no login being done, then your only hope is if each user only uses one PC, each PC only has one user, and the IP addresses are static and NEVER change. Odds are, you can't do it.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
thank you
yes each user has username and password, and i want to display the treeview after login
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
