You searched for the word(s): userid:816798

More Search Options

RSS Available

• Re: Problem in data reader

  I resolved the problem by little bit modifying my code public void timeout_btn_Click(object sender, EventArgs e) { SetTextBoxValue(timeout_txt); this.Punch_btn.Text = "Punch-In"; MembershipUser memberUser = Membership.GetUser(); Guid userId = new Guid(memberUser.ProviderUserKey.ToString()); string strconn = ConfigurationManager.ConnectionStrings["employeeConnectionString"].ConnectionString.ToString(); SqlConnection conn = new SqlConnection(strconn); SqlCommand cmd = new SqlCommand

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 9/22/2008

• Problem in data reader

  Hello frnz, I have a problem in Data reader. Have a table named 'Time1' with fields as (time_id (PK),User_Id(FK),time, time_in, time_out). what i'm doing here is the values for time_id is as Indentity Specification field, User_Id I'm getting from MembreshipUser, time field in getdate() and taking date.Today,time_in and Time_out is a user input field. Also I have a Button associated with Time_in_textbox and Time_out_textbox one for each. So on time_out_button_click have an insert query

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 9/22/2008

• Re: Insert Query

  Anybody plz help me. I'm stuck regards Vagz

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 9/9/2008

• Re: Insert Query

  Okay even if I've UserId in employee table then too my problem wont get solved. What I want here is that through emp_id the employee must be recognized ,also when the employee login then there shlould be something where I can capture the emp_id from emp table. Can this be done ,if yes plz hepl me out. Any suggestion is appreciated

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 9/8/2008

• Re: when i run the sqlserver management studio it gives error

  Are you able to connect to your Database Engine....? Regards Vagz

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 9/2/2008

• Re: Insert Query

  okay I'll have the UserId field in my emp talbe but how will connect it UserId from aspnet_membership . i mean there'll be a relation b/w them where UserId'll be FK. but how will enter this value into the table? I have this doubt. also see I have an admin who only has the access to enter , delete ,update the Employee details in Emp table and also he is the one who is creatin New Users through Create User Wizard. Now dd u get my scenerio... so help me figure out. Thanks a lot Regards Vagz

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 9/2/2008

• Re: Insert Query

  No I've a table emp which has emp_id and the other table aspnetdb_membership which has UserId. Do I need to have UserId in emp talbe also..?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 9/2/2008

• Re: Insert Query

  See the UserId in aspnet_membership is not same as Employee emp_id so by using the code what u have posted wont give me the emp_id but i'll give me the UserId which is a uniqueindentifier . regards Vagz

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 9/2/2008

• Insert Query

  hello frnz, I want an MS SQL query for insert command for the following scenerio. In my database named Employee I've included the aspnetdb through aspnet_regsql for adding Membership,Roles, Security, so my db contains all the tables of aspnetdb along with my created tables such as emp having all the employee deatials with emp_id as PK,depart having all the departments deatils with depart_id as PK, then I ''ve a table named time which records all the Punch-In/Out timings of each emloyee

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 9/2/2008

• Re: Can we modify the ASPNETDB

  I know that this database is a procedure used for security,profiles and roles. See I've database named Emplyee having tables dbo.emp (for emplyee details),dbo.time(recording the punch-in and punch-out timings for each emplyee). Now I've used aspnet_regsql with my database Employee. Also I'm using WAT configuration for creating users,roles and access rights. In my dbo.emp have a field emp_id as (PK,varchar(30),not null) and now I wanna have this emp_id in dbo.aspnet_Membership,dbo.aspnet_Users

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vagz on 8/28/2008