How to increment string value in asp.net using for loop

Santosh Vishwakarma

My code is here I am getting an error during the run program.

for (int date= Convert.ToInt16(concat1) ; date>Convert.ToInt16(concat); concat=(concat+1))

{

MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Datavos3000"].ConnectionString.ToString());

string str = "select id as CallerID,feetime as Duration,fee as Charge,callere164 as Gateway_ID,calleee164 as Number_Dialled,callerip as Caller_IP from " + concat + " where feetime>0 or customeraccount='" + Hidden.Value + "' group by customeraccount limit 1000;";

MySqlCommand cmd = new MySqlCommand(str, connection);

MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);

DataTable set = new DataTable();

connection.Open();

adapter.Fill(set);

grid.DataSource = set;

grid.DataBind();

connection.Close();

}

Please Help me.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Try this Code:
int intVariable = 0;
intVariable++;
string output = intVariable.ToString().PadLeft(6, '0');
Rajanikant Hawaldar7y ago
Hi Santosh, your using two variables concat and concat1 , are these are string? if both are string then why you are not casting below line cancat= cancat+1 and somewhere your casting concat int and your assigning query to string str using additional ; symbol at end of the query before " symbol please check this let me know issue is fixed or not Thanks
Visukumar Selvaraj7y ago
you are using loop every time. so make the adapter declaration outside of the loop, otherwise you will not get the values. try debugging the application and try to find exact error