|
When the user does not enter a value, retrieving the Text property returns an empty string. You are attempting to perform an implicit conversion of "" to a date, which is not possible. You'll need to guard against this by testing to ensure that there is a value in the textbox before converting, or by using DateTime.TryParse.
Hope that helps. 
--Jesse "... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi
|
|
|
|
|
first check
txt1 means the textbox having Date Value.
if txt1.text="" then
in query pass null keyword for that Date Field.
i.e. here abc is the table with 2 columns frmdt(Date)& name(Text)
insert into abc values(null,'"& txt2.text &"')
|
|
|
|
|
hai,
i have one problem ,i want to give data at runtime in web application,but i want to give input in table format like as gride view .
minimum 10*10 empty rows and coloumns to display.
yours ,
vishnu vardhan.menta
|
|
|
|
|
you can use array of controls and generate the controls dynamically..
you can even fix minimum number of rows to be generated everytime i.e. 10 in this case.
on SAVE, just calculate the number of elements in array and LOOP through the elements and FIND CONTROL, detect value and fire save query...
OR add the values into a datatable and perform save operation with COMMANDBUILDER
its simple answer
Ashish Sehajpal
|
|
|
|
|
Why not use a grid view. Or a repeater...
|
|
|
|
|
|
John Sundar wrote: the record is to store in a log file (.txt).
how to implement.?
Try Googling log4net
led mike
|
|
|
|
|
My project runs very fine in local machine with local Mysql
but when is forced to connect with remote Mysql it shows
"Unable to connect to any of the specified MySQL hosts."
Can any body know how to solve this.
my connection string is:
connectionString="server=XXXX.secureserver.net;user id=myuserid;password=mypwd;persist security info=false;database=SampleDB;pooling=false;"
providerName="MySql.Data.MySqlClient"
Thnx
regards
Prabu
|
|
|
|
|
is it set up to allow remote connections?
Do you need to use differnet login credentials for remote access?
check this out
|
|
|
|
|
can u able to explain me in short about the configuration settings & conection string required for remote mysql connection with asp.net
|
|
|
|
|
try connecting to the database server using some database client (maybe SQLYog etc.) and verify it gets connected to it and you have access to the database.
Ashish Sehajpal
|
|
|
|
|
no from there (sqlyog) also its throwing error "unable to connect"
|
|
|
|
|
dear it means....credentials are wrong...plz have accurate login id and password, port and then try connecting..
rest is OK
cheers !
Ashish Sehajpal
|
|
|
|
|
Hi,
I want to Highlighted the newly added record into the grid and also want that record will be display at the top of the grid
How can I do this?
Thanks
|
|
|
|
|
too many solutions....
sort the grid on the basis of IDENTITY and change the background color of the first record from CODE BEHIND Databound event (use a flag to mark the end of color changing process...declare a boolean var with initial value FALSE. check for value to be FALSE in databound event and make it TRUE after changing color..)
other efficient solutions are also possible... you can event fetch the value in a flag field from database side (by deciding in stored procedure... more simpler to implement)
Ashish Sehajpal
|
|
|
|
|
hi guys
is there a way i can automatically increaes a list of numbers by 1
e.g.
1,2,3,4,5
increase each one so its
2,3,4,5,6
Should I be using an array to do this or a loop
The numbers are currently stored in a listbox
thanks for any help
cheers 
|
|
|
|
|
use foreach to iterate over your items from your datasource ( or direct in the items collection if there's no data source ) and add 1 to each one.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I think there is no need to have any array
Just check the last number and first number and iterate through it while incraesing the value. First chech Max
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Hey
cheers for the replies, managed to get this to work:
foreach (ListItem item in listboxact.Items)
{
string test = item.ToString();
int i_number = Int32.Parse(test);
i_number++;
string test2 = i_number.ToString();
listbox1.Items.Add(test2);
}
what do you think? it works but is there a better way?
|
|
|
|
|
Hi
OK got another q now:
with the loop is there a way to set it so it only runs for a certain few numbers
e.g.
i have
2,3,4,5,6 in the list
and I want to loop through 3,4,5,6 but NOT 2.
so somehting like
foreach (ListItem item in listboxact.Items > 2)
any help would be great
cheers
|
|
|
|
|
If you're always looking to skip the first item, then you could use a simple for loop to start at the second item in the list.
for (int index = 1; index < myDropDown.Items.Count; index++) { string value = myDropDown.Items[index].Value; // Work here. }
If you're looking to skip arbitrary values, you could test for them and skip past them.
foreach (ListItem item in myDropDown.Items) { if (item.Value == "2") { continue; } // Work here. }
Hope that helps.
--Jesse "... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi
|
|
|
|
|
hey
Yeah I'm looking to do arbitrary values
basically I want to run the loop for eahc number which is after a number the user has entered
I tried the second example you put above and tried
if (item.Value == "4")
but it still increased every number rather then just the numbers after 4
why would this be?
thanks for the help so far
|
|
|
|
|
For that, you'll have to do more then check against a single number. The easiest way is to eat some casting cost and compare the current value to the one that you selected. Something like:
int controlValue = Int32.Parse(selectedValue); int currentValue; foreach (ListItem item in myDropDown.Items) { currentValue = Int32.Parse(item.Value); if (currentValue < controlValue) { continue; } // Do Work }
will increment only numbers >= your selected value.
--Jesse "... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi
|
|
|
|
|
cheers that worked thanks!!
Just got to get two columns in a listbox and then figure out how to enter into database to update exisitng data
but i can do that myself(hopefully)
cheers!!!!!!!!! 
|
|
|
|
|
There is one more way
Just Remove the first 0 the index and add one item at last index that should be grater that Last but one
e.g
you have 2 3 4 5 6
Remove 2 and add 7 at last index
3 4 5 6 7 got it
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
