Comments by sanjaysgh (Top 60 by date)

where to call this function

ie11

yes i am sure no space is there

tabtype contain 5,7,11

and How to loop it

,7,8,11

Its not working

provide any solution

it is inside grid

sir its not working still i am getting syntax error

It is not working

id like
08SANJAY3001
08SANJAY3002
08SANJAY3003

i want date in 2014/12/10 4:39 PM this format

i want validate atleast one textbox to search record

yes

its not working

but sir i want to fetch both column from sub query is it possible

tnak u sir its working fine thanks a lot

sir its working but number is not incresing like 1,2,3 still getting srno like 1,2,2,2,...

plz help

sir it not running i tried after sometimes.

in da.fill(ds);

sir i am getting error at this location

public static DataSet ExecuteDataset(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
//create a command and prepare it for execution
SqlCommand cmd = new SqlCommand();
PrepareCommand(cmd, connection, (SqlTransaction)null, commandType, commandText, commandParameters);

//create the DataAdapter & DataSet
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();

//fill the DataSet using default values for DataTable names, etc.
da.Fill(ds);

// detach the SqlParameters from the command object, so they can be used again.
cmd.Parameters.Clear();

//return the dataset
return ds;
}

my take varchar(1000)

i mean i have web service already and i am using it for another application but now i want to use the same service for third application thn how can i do this ...

thanxs Tadit sir

sir i did it by mistake now i accept ur answer again

sir in txtSadate.text i am getting {30-10-2013 00:00:00} and after this DateR2 i am getting {01-01-0001 00:00:00}

i am getting error in
DateTime DateR2 = Convert.ToDateTime(dt.ToString(), System.Globalization.CultureInfo.CreateSpecificCulture("en-US").DateTimeFormat);
line

i am getting in txtSdate.text is {30-10-2013 00:00:00}

date is in mm/dd/yyyy format

not clear...

thanx

i mean how to page automatically redirect on login page if session time expired

i paste the code above

my problem is that when i try to validate login form it's not validating

and my code is

<script type="text/javascript">

function openEditorWindow(forumID) {
var oReadingWnd = radopen("~/AddArchives.aspx?id=" + forumID);
oReadingWnd.Center();
}
</script>
<script type="text/javascript">
function GetTextBoxValue() {

var hyp = document.getElementById('<%= JournalName.ClientID %>');

var hyp1 = document.getElementById('<%= hplAddAcrhives.ClientID %>');
//alert(hyp.innerHTML + 'su' + hyp.innerText);
hyp.innerHTML = 'New Text';
//alert(hyp.innerHTML);
hyp1.href = 'AddArchives.aspx?JournalName=' + (hyp.value);
}

but i am trying to passs string through Javascript

ok

ok...

sir it is not working

ofcourse sir i am using datepicker here

actauly is this when i am trying to insert date like 10/25/2013 than getiing error and when i tring to insert 25-10-2013 or 10-25-2013 than it insert successfully.....

actauly is this when i am trying to insert date like 10/25/2013 than getiing error and when i tring to insert 25-10-2013 or 10-25-2013 than it insert successfully.....

getting error while using tryparse asking for 2 arguments

b.Dob = DateTime.Parse(txtdob.Text);
when i debug program i am getting exception that String was not recognized as a valid DateTime.

according to condition

you have to disable coloum of gridview

sir this code is not working

here i am getting error :
loginInfo.To.Add(new MailAddress(txtEmail.Text));

plz clarify it again....

plz help me

string strConnection= System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;

// string strSelect = "SELECT Username,password FROM registration WHERE emailid = @emailid";
string strSelect = "SELECT name FROM registration WHERE email_id = @email_id";

SqlConnection connection = new SqlConnection(strConnection);
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = strSelect;

//SqlParameter email = new SqlParameter("@emailid", SqlDbType.NVarChar,100);
SqlParameter email = new SqlParameter("@email_id", SqlDbType.VarChar, 100);
email.Value = txtEmail.Text.Trim().ToString();
command.Parameters.Add(email);

DataSet dsPwd = new DataSet();
SqlDataAdapter dAdapter = new SqlDataAdapter(command);
connection.Open();
dAdapter.Fill(dsPwd);
connection.Close();
if(dsPwd.Tables[0].Rows.Count > 0 )
{
MailMessage loginInfo = new MailMessage();
//loginInfo.To.Add(txtEmail.Text.ToString());
loginInfo.To.Add(new MailAddress(txtEmail.Text));
loginInfo.From = new MailAddress("mail@gmail.com");
loginInfo.Subject = "Forgot Password Information";

loginInfo.Body = "Username: " + dsPwd.Tables[0].Rows[0]["Username"] + "<br><br>Password: " + dsPwd.Tables[0].Rows[0]["password"] + "<br><br>";
loginInfo.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.EnableSsl = true;
smtp.Credentials = new System.Net.NetworkCredential("mymail@gmail.com", "password");
smtp.Send(loginInfo);
lblmsg.Text ="Password is sent to you email id,you can now Login";
}
else
{
lblmsg.Text = "Email Address Not Registered";
}
}