|
I am using a textbox to insert time into a databse table "SQL Server", The column data type in the table is datetime. When i insert it an run the page i see the date 1/1/1900 in the GridView but i don't want it to appear. What should i do to solve this problem.
Thanx in advance for ur help.
yasso
|
|
|
|
|
you have to check the date before displaying on the page, you can do it in sql statement or on rowdatabound, in sql, you can do,
case when datefield='1/1/1900' then '' else convert(varchar, datefield, 101) end as datefield
in rowdatabound
if(row.Cells[datefieldindex].Text=='1/1/1900')
row.Cells[datefieldindex].Text = string.Empty;
-----
|
|
|
|
|
Thx for ur help but i didn't know how to solve it  , i am a new developer and i have a little experience. Lets say i want to use the rowdatabound, but what is that a property of the Gridview??
I am using a GridView to display the data and one of its columns displayes the time "with the date that i don't want it to appear". where should i put the code that u sent????
Thanx for ur help
yasso
|
|
|
|
|
well the following code should be used in your SQL STATEMENT or stored procedure whateevr you are using
case when datefield='1/1/1900' then '' else convert(varchar, datefield, 101) end as datefield
or use OnRowDataBound="gv_RowDataBound" in html where you insert the gridview control and int he code behind create a sub
protected virtual void gv_RowDataBound(object source, gridviewroweventargs e)
and use this in this sub
if(row.Cells[datefieldindex].Text=='1/1/1900')
row.Cells[datefieldindex].Text = string.Empty;
look at this [^] for gridview
-----
|
|
|
|
|
Hi,
insted of using text box for date user date picker control
http://www.basicdatepicker.com/
thanks
|
|
|
|
|
Thanx Naif i downloaded it and i am using it on the pages but i am using the insert query in the sqldatasource to write to database, all the other controls in the page appear in the controlID: except the timepicker, how can i use it to write data to database??
Thanx for ur help
yasso
|
|
|
|
|
How can I come to know that in each post back button is clicked or not.
seema
|
|
|
|
|
In your form load event you can check the IsPostBack variable. It is set to true when the page posts back to the web server. Each individual button probably should have it's own onClick event in your code behind.
Ben
|
|
|
|
|
|
Hi..
I have a textbox that was firing Text_changed event when the user press Enter.but now it is not firing any more.But the handler for this event is executed when a postback occur(for example when I click a button).
The only change I made it was putting the asp:textbox in a <DIV> instead of a <table><tr><td>.
I observed when I press enter in the textbox I hear a sound(one of the windows usual sounds).
Could any one tell me how to solve this problem and make it working as before(when the user press Enter)?
I am too late but i will never give up
|
|
|
|
|
If you set the autopostback to true on the textbox it will postback when the text changes. I don't think you really want to do this, since it takes time for the web page to reload for each key press. You probably want to use some javascript for you text change event.
Ben
|
|
|
|
|
Hi..
It was working without autopostback.and the event was only fired when the user press Enter not any other key press.
I am too late but i will never give up
|
|
|
|
|
If it used to work it was by error. The enter key was probably causing a button to get pressed, since that what it does on the web. I would guess a one point that button didn't have any code in your code behind so you didn't notice it. What you are trying to do doesn't work.
Ben
|
|
|
|
|
Sorry but I don't think so because the textbox have the access(which change using TAB).
May you explain to me what do you mean by:
'since that what it does on the web.'
Please explain to me your idea because this is the only problem remain to me to upload updates to my old website.
I am too late but i will never give up
|
|
|
|
|
|
You can make textchange event for text box
by using java script.
If u need i'll explain it..
Sherin Iranimose
|
|
|
|
|
I need help, I am trying to print results loaded into a Datalist and I have not been able to make any headway. The datalist is loaded from a query and has the option of displaying detailed info or summary. I would like to print out (which ever is selected) the results as they are in the datalist.
I am new to this work and need some assistance.
hutch
|
|
|
|
|
I have a button( btnLogOut)in my master page. In page_load event of this master page I want
to verify if the button is clicked or not.
How can I do that.
Thanks in advance.
seema
|
|
|
|
|
|
I have a textbox, that records the file names of upload files, and seperates it out with a , I would like to create an array that would read this text box, and seperate it out, so I can create a link for each file. I could really use some examples in code. My codebehind is C#
|
|
|
|
|
string[] FileNames = txtFileNames.Text.Split(',');
|
|
|
|
|
So then it will string as them as? like how do I assign each portion of the string a varible? Or am I not getting something as simple? Trying to figure out how I would link them.
|
|
|
|
|
Something like this no?
string FileNames[1]=dr["HyperLink1"].ToString();
|
|
|
|
|
Put a placeholder control in the screen, read the filenames and dynamically add link buttons and the click event for each of the links.
|
|
|
|
|
If I understood any of this, I imagine I'd be in good shape. Pardon me, I've only been using .net for about 3 months before, that had never developed anything, and was given a full blown, huge ass project by my work, they know I can't code C# and I am still learning, they just elinated my job... I hate to be a pain in the ass, but could you explain a little further?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
