Comments by nityasri (Top 36 by date)

ok sir..sorry

no error in DB update statement...when i write update query in database it executes (updates) properly...but from the form that is from text box it is not getting updated to database

alright sir thank you

i tried the above code if (confirm('Message')) {
window.location = "ConfirmPage.aspx";
}
but its not working may be i am missing some namespace i think..what namespace should we use here.sir

thanks a lot yaar...problem solved:)

thank u griff

what namespace we have to use here sir?

@andreas thanks

@krunal..thanks

@wmdroshan thanks for guiding me

thanks yaar

@griff thank u

@amit thank u

try
{
string myString = txtEmail.Text.ToString();

string result1 = myString.Split('@')[1];---->i m getting the error here as index was outside the bounds of array

s sure..

This is were i am getting the error...

protected void btnSubscribe_Click(object sender, EventArgs e)
{
string arrvalues = null;
for (int i = 0; i < CBL1.Items.Count ; i++)
{
if (CBL1.Items[i].Selected)
{
arrvalues = arrvalues + CBL1.Items[i].Value + ",";
}
}

if (arrvalues==null)
{

}
else
{
if (arrvalues.EndsWith(","))
{
arrvalues = arrvalues.Remove(arrvalues.Length - 1, 1);
}
My_Util Util = new My_Util();
DataSet ds;
ds = Util.CheckusernameMail(txtEmail.Text.Trim());
if (ds.Tables[0].Rows.Count > 0)
{
//My_Util Util = new My_Util();
Util.SetConnection();
Util.sql_con.Open();
SqlCommand cmd;
// cmd = new SqlCommand("insert into offsale.OS_Mailinglist1(UserName,Area_of_interest,Mail_Pwd)values('" + txtEmail.Text.ToString() + "' ,'" + arrvalues + "','" + pwd.ToString() + "')", Util.sql_con);

cmd = new SqlCommand("update offsale.OS_Mailinglist1 set Area_Of_Interest='" + arrvalues + "' where UserName='" + txtEmail.Text.ToString() + "'", Util.sql_con);
cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Area of Interest Updated Successfully');", true);

Util.sql_con.Close();

foreach (ListItem item in CBL1.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
}

txtEmail.Text = "";
Label1.Visible = false;
passwrd.Visible = false;
btnSend.Enabled = true;
btnSubscribe.Enabled = false;

}
else
{
Util.SetConnection();
Util.sql_con.Open();
cmd = new SqlCommand("insert into offsale.OS_Mailinglist1(UserName,Area_Of_Interest,Mail_Pwd)values('" + txtEmail.Text.ToString() + "' ,'" + arrvalues + "','" + ViewState["pwd"].ToString () + "')", Util.sql_con);
// cmd = new SqlCommand("insert into offsale.OS_Mailinglist1(UserName,Area_of_interest,Mail_Pwd)values('" + txtEmail.Text.ToString() + "' ,'" + arrvalues + "','" + passwrd.Text.ToString () + "')", Util.sql_con);



cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Successsfully Registered your Email ID and Area of interest.');", true);

//ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Register your Password to MailingList')", true);
// return;
Util.sql_con.Close();

foreach (ListItem item in CBL1.Items)
{
if (item.Selected == true)
{
item.Selected = false;
}
}

txtEmail.Text = "";
Label1.Visible =false ;
passwrd.Visible =false ;
btnSend.Enabled = true;
Label2.Visible = true;
Label2.Text = "Please select your Area of Interest & Subscribe";
btnSubscribe.Enabled = false;


}
}
}

@kiran thank u

@ankit..thanks a lot

i didn't try ..i dont know how to use the code for it

@griff..thank u

ok..thanks

@original griff...we are using it in a mobile web application...

DropDownList1.Items.Add(ds.Tables(0).Rows(i).Item(0))

@krunal....in dataset i am getting error...

m sorry...yes, sql server

i am not able to insert the data in to the database it is showing the below mentioned error as:

error:cannot find the object "timeticket_fullCT"because it does not exist or you dont have permissions.

what is the solution for this????

hi friend tell me sql server problem

actually the session given in third line is given in new user registration page...so that the name given in text box of register page will be defaultly thrown rite...so i used that

@soumen...thanks a lot

but i use validate function(like phone number checking) also in this registration form ..so if i click submit button will the validate function will be carried out or the confirm box function will be carried out?..please help me knw ...

thank you