|
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... "
|
|
|
|
|
Check this code Might be helpfull
int num= Int32.Parse(ListBox1.Items[0].Text);
// i know the total number of numbers are 4
ListBox1.Items.RemoveAt(0);
num = num + 4;
ListBox1.Items.Add(new ListItem(num.ToString()));
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... "
|
|
|
|
|
I'm not sure if thats what i need
basically let me explain again
I have
1,2,3,4,5,6
someone wants to add the number 3
i need the number 3 to be added
then the rest of the numbers including 3 increase by 1
1,2,3,4,5,6,7
I have
foreach (ListItem item in listboxact.Items)
{
string test = item.ToString();
int i_number = Int32.Parse(test);
i_number++;
string test2 = i_number.ToString();
ListItem item2 = new ListItem();
listbox1.Items.Add(test2);
}
which increases every number by 1
is that clearer?
|
|
|
|
|
If you are always following the pattern that you illustrate above, with the items sorted, you may want to consider simply removing the lowest item in the list and adding a new item. Something similar to the following code would allow you to achieve your goal without needing to loop at all.
int topValue = Int32.Parse(myDropDown.Items[myDropDown.Items.Count - 1].Value); string newValue = topValue++.ToString(); myDropDown.Items.Add(new ListItem(newValue, newValue)); myDropDown.Items.RemoveAt(0);
Hope that helps.
--Jesse "... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi
|
|
|
|
|
Hi Friends,
I m decresing the time using javascript user defined function startTimer1(), I am calling that function in body load event Its working fine but user clicks server button the time is decreasing very fast.
My logic is right.i dont know where I call that function.
This is my coding
function startTimer1(h,m,s)
{
if(document.getElementById('txt').innerHTML=="00:00:00")
{
alert("Your time is Over,Now the Application is going to close");
//self.close();
window.close();
return false;
}
var today=new Date();
if(h=="0" && m=="0" && s=="0")
{
h=00;
m=01;
s=00;
}
else
{
if(s=="00")
{
s=59;
if(m=="00" && h!="00")
{
h=parseInt(h)-1;
m=59;
}
else if(m!="00" && h=="00")
{
m=parseInt(m)-1;
}
else if(m!="00" && h!="00")
{
m=parseInt(m)-1;
}
else if(s=="00" && m=="00")
{
if(h!="00")
h=parseInt(h)-1;
}
}
else
s=parseInt(s)-1;
}
// add a zero in front of numbers<10
h=checkTime(h);
m=checkTime(m);
s=checkTime(s);
document.getElementById('txt').innerHTML=h+":"+m+":"+s;
t=setTimeout('startTimer1('+h+','+m+','+s+')',1000);
}
function checkTime(i)
{
if (i<10)
{
i="0" + i;
}
return i;
}
|
|
|
|
|
so you mean this code is on page_load, but if a user click a button and it posts back to the server then the timer countdown increases in speed?
Please explain your problem a bit more
cheers!
|
|
|
|
|
Not page_load(),
the problem is while clicking server control its getting postback and body onload event is calling.So time is decreasing fastly.
|
|
|
|
|
you need to put the timer on a page init, if its onload then every time page loads or re-loads it will affect the timer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
