Try this javascript function

<script type="text/javascript">
function myfunction(str1)
{
window.location.href='Default2.aspx?id='+str1;
}
</script>

Regards, Karthik K...

Try this

DateTime.Now.ToString("hhmmss");

If you need AM/PM in time, then use

DateTime.Now.ToString("hhmmsstt");

and also try this link Datetime in Oracle[^]

Regards, Karthik K...

Try this GOOGLE AJAX Search API[^]

Regards, Karthik K...

mjawadkhatri wrote:

Hi.. How to add two textbox text in one field of database??

string str = textbox1.text + textbox2.text;

and add the str to database field.

Regards, Karthik K...

Just try this,you will get more ways to bind data Bind data to table ASP.NET

Regards, Karthik K...

Try this link Send Email Automatically[^]

Regards, Karthik K...

Try this sample code

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = sqlConnection();
            cmd.CommandText ="your query";
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adapter.Fill(ds);
            datagridview1.DataSource = ds;

Regards, Karthik K...

Try this VS 2008 Team[^]

Regards, Karthik K...

Don't ask the same question in multiple forums.

Regards, Karthik K...

mjawadkhatri wrote:

cmd.CommandText = "Select empid ,sysdte from timemgmt where empid = '" + textBox1.Text + "' and sysdte ='" + label19.Text + "'";

your search query is ok. After that use like this way,

if(odr.read())
{
MessageBox.Show("You Already IN this ID Today");
}
else
{
cmd.CommandText = "insert into timemgmt empid, sysdte, intime, outtime) values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
}

Try the above code.Use the Breakpoints and try to rectify where the error comes.

Regards, Karthik K...

There is a error in insert statement try this

cmd.CommandText = "insert into timemgmt(empid,sysdte,intime,outtime) values ('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";

Regards, Karthik K...

Then instead of Hasrow,use like this replace the below code

        if (dr.HasRows == false)
        {
            //insert new row
        }

new code

        if (!dr.Read())
        {
            MessageBox.Show("No records");
        }
        else
        {
            MessageBox.Show("Records Found");
        }

Regards, Karthik K...

Try this for Encrypt and Decrypt Encrypt and Decrypt Data with C#[^]

Regards, Karthik K...

For Oracle, replace SqlConnection,SqlCommand,SqlDatareader to odbcConnection,odbccommand and odbcdatareader

        odbcConnection con = new odbcConnection("your connection string");
        odbcDataReader dr;
        string str = "your query";
        odbcCommand cmd = new odbcCommand(str, con);
        dr = cmd.ExecuteReader();
        if (dr.HasRows== false)
        {
            //insert new row
        }

Regards, Karthik K...

Try the sample code

        SqlConnection con = new SqlConnection("your connection string");
        SqlDataReader dr;
        string str = "your query";
        SqlCommand cmd = new SqlCommand(str, con);
        dr = cmd.ExecuteReader();
        if (dr.HasRows== false)
        {
            //insert new row
        }

Regards, Karthik K...

Try this for ASP.NET AJAX WAS Here - Part 3 : Auto Complete TextBox[^] Try this for C#.net(Win Application) AutoComplete TextBox[^]

Regards, Karthik K...

Try this. First Create a class in App_Code,like the below

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{
public Class1()
{
//
// TODO: Add constructor logic here
//
}

public string test()
{
    return "Test";
}

}

and create the object for that class in default.aspx.cs, like

Class1 cls = new Class1();

and call the function "Test" in default.aspx.cs

string str = cls.test();

Regards, Karthik K...

Try this

        DateTime dt = DateTime.Now;
        MessageBox.Show(dt.ToString("dd/MMM/yyyy"));

Regards,
Karthik K...

Always welcome and good luck.

Regards, Karthik K...

Try the below sample code query = "select username from tablename where username = '" + usr.text + "'"; sqlcommand cmd = new sqlcommand(query,con); sqldatareader dr; dr=cmd.executereader(); while(dr.read()) { if(dr["username"].tostring() == usr.text) { true user } else { false user } } dr.close();

Regards, Karthik K...