Comments by geo thomas (Top 39 by date)

i could display values in the gird from database..now i want to add a new colum to the grid.the grid should contain system time

i could display values in the gird from database..now i want to add a new colum to the grid.the grid should contain system time

tnq

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'where'.

I DOT READ THE DATA FROM DATABASE ..
AM ALLREADY DONE THAT..I WANT TO INSERT DATA TO THE TABLE WHERE CELLLS ARE EMPTY.

LET ME CHECK

srry..this is not what i am looking for..

its not what i am lookin for..
am having a data table in sql server 2005.
on a particular row some columesw doent have any datas..
how can i check that cell contain values or not.

string a = "select Break1_Start,Break1_End,Break2_Start,Break2_End,Break3_Start,Break3_End from Attendance_Register where Employee_ID='" + da.remEMP(ei) + "' and Date='"+ d +"' ";
dt = da.getdetails(a);
// dt is datatable obj
//getdetails() which is used to get data from database

how to check wether aparticular cell contain datas or not?

paricular cell

oh..its not working..help

kk.let me check

yes.i want to replace the windows logon screen.
how can i do dat?

how can i get my login form right after bootig.what should i do with my exe file?
do i need to add any extra code for it?

i want my login page right after booting,,,with out this login no one could access any featurs of windows..

k.

thank u very much..
its work...thanks again..:-)

srry..is not working?am getting error
Error 5 'Employee_Login.Form1.txt_EId' is inaccessible due to its protection level

kk..thank u

string rem = txt_EId.Text;
string sa;
sa= rem.Replace("emp","");
int a = Convert.ToInt32(sa);
//MessageBox.Show(a.ToString());
SqlConnection s = new SqlConnection();
s.ConnectionString = @"Data Source=.;Initial Catalog=employee;User ID=sa;Password=tecfwds@hg25tr32";
s.Open();
string st = "select Employee_Id,Password from Employee_Details where Employee_Id='" +a.ToString() + "' and Password='" +txt_pwd.Text+ "'";
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
da.SelectCommand = new SqlCommand(st, s);
da.Fill(dt);
if (dt.Rows.Count > 0 && rem.Contains("emp"))
{
MessageBox.Show("login successfull");
}
else
{
MessageBox.Show("invalid user id and pass word");
}

this code works

its not storing in the data base as emp0000001...it stores as 1..

i was tryin to access the text bob name in a form to a class...

thank you

windows form

thanku....its solved nw...

no...its not working

no..txt_serch_by" is not added on form correctly...


#endregion

private System.Windows.Forms.Button button1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.ComboBox cmb_serch;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.LinkLabel linkLabel1;
private System.Windows.Forms.Label lbl_serch_by;
private System.Windows.Forms.TextBox txt_serch_by;

thank you

let me try

after turning on a computer..need to direct login on a c#.net created login window.
with out this login authentication user cant use the system

with out this login authentication user cant use the system

after turning on a computer..need to direct login on a c#.net created login window?