You can use Columns property to increase with for multiline texxbox.

Hello experts.. How can i implement sign in popup like that exist in codeproject.com Please suggest me the way to implement that using Jquery or Javascript.I also have to show details from the database. :) thanks in advance :)

I am creating report for displaying continuous absent for more than 2 days.Query is build and working fine.Range is passed by using @StartDate and @EndDate. but problem is if In between two absent week off comes then it is also considered as continuous absent.i want to add that functionality to the existing query.How can i do that?

Existing query is:

WITH Dates
(
EntryDate,
EmployeeNumber,
Status,
Days,
EmployeeCode,
EmployeeName,
DeptName,
JobName,
HOD,
Supervisor
)
AS
(
SELECT
a.[DATE],
a.EmployeeID,
a.Status,
1,a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
FROM
tblEmployeeAttendance1 a

WHERE
    a.\[Date\] between @StartDate and @EndDate and (a.status='AB' OR a.Status='O')
-- RECURSIVE    
UNION ALL

SELECT
    a.\[DATE\],
    a.EmployeeID,
    a.Status,
    CASE WHEN (a.Status = Parent.Status) THEN Parent.Days + 1 ELSE 1 END,
    a.EmployeeCode,a.EmployeeName,a.DeptName,a.JobName,a.HOD,a.Supervisor
FROM
    tblEmployeeAttendance1 a 
INNER JOIN
    Dates parent
ON
    datediff(day, a.\[DATE\], DateAdd(day, 1, parent.EntryDate)) = 0 
AND
    a.EmployeeID = parent.EmployeeNumber  where a.\[Date\] between @StartDate and @EndDate and (a.status='AB' OR a.Status='O')

)
SELECT * FROM Dates where days>=2 order by EmployeeNumber, EntryDate

I have one SQL Table with 2 columns as below Column1: ProductionDate - DateTime - Not NULL Column2: Quantity - Int - Not NULL Now There are 2 Records in Table 1-1-2012, 5 1-3-2012, 7 Output of Result should be as below if i give date range StartDate as 1-1-2012 and EndDate as 1-15-2012 1-1-2012 5 1-2-2012 0 1-3-2012 7 1-4-2012 0 1-5-2012 0 1-6-2012 0 . . . 1-15-2012 0 Means Query should return all the dates of given range with Quantity and if no entry in Table then 0 for Quantity. How to Do it? Please suggest with Query

Hello friends, I need query which will check user supplied date range is in between the existing table startdate and enddate. if any of the date of user supplied date range is in between the tables start date and end date,it should retrun that record from table. for example user supply date range is from 1 may 2012 to 5 may 2012. then query must check that 1 may 2005 2 may 2005 3 may 2005 4 may 2005 5 may 2005 (all dates) is in between startdate and enddate of existing table. please reply...Thanx in advance...

Hello friends, I need to fill all employee of all department in dropdown.Employee list should be diplayed in grouping as per deparment and heading of the department should be displayed. so Is there any free available dropdown control having grouping functionality. pls reply.Thanks in advance..

Yes i am already doing it in this way. i am going to open the connection when i need to perform Insert/Update/Delete. public void Insert(string str) { try { if (con.State == ConnectionState.Open) { con.Close(); } con.Open();//Application execution stops here. cmd = new SqlCommand(str, con);//str contains query to execute cmd.ExecuteNonQuery(); } catch { } finally { con.Close(); } }

Hello friends. I hv one application that runs continuously for Month or two.And the application is using any remote PC database. When i start the application i set all connection object required for that. In some of the cases When i go for insert/update/delete operation at that time connection is broken so application stops working.it goes into idle state.Nothing is happening over there. So i want to check that is there connection is exist or not with Remote PC in C#.NET? Please reply. Thanks in advance.

modified on Friday, February 18, 2011 2:25 AM

Hi friends, I want to set corners of buttons rounded and backcolor of TabControl is transperent but i don't find any backcolor property for TabControl. I have tried with control.region for Rounded corners but ooops.. it fails for me. So please guide me how can i do this two things. Thank in advance.

Hello friends, I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc. I want to decrease it and want to make it execte withing 30-40 sec.. It is getting data of whole month with subquery of 1-30 date and each joining 3-5 tables for 300-500 persons. so any ideas.... :confused: :doh: One thing that i can do some process in background and insert fetched data to the some other table and at the time of executing above query fetch data from that table. if its possible then how can i do it?Is there any other way to solve this problem? Thanks in advance.. :) RAHUL PATEL

Thanks a lot dear friends for your valuable time. I have installed SQL EXPRESS 2008 but it was not EXPRESS R2 version thats why its creating problem. I came to know that thing when i was changing the initial size of database to 5500 MB. Thankx.

Thanks for your reply. i upgraded sql 2005 express to sql 2008 EXPRESS WITH TOOLS that is R2 version of SQL EXPRESS. But still the same problem there....

Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in

hiii friends.. We are developing one application which capture image connected USB camera.we also want to view continueous frame from camera in some control or anything. we have serched google and found using WIA.But the problem is that it does not support continueous frame from camera. Now we are searching any control(.Net control or may be third party control. whatever) which provides such facility. Thanks in advance.

hiiii friends, I am facing problem in opening crystal report. It gives error saying Invalid username or Password I have three reports in my application.Two of three are opens successfully but one reports asks for username and password. I have provided servername,username,password carefully in my source code. When i run the application from visual studio,it runs perfect. but in case of installing application from setup it gives that error. I think some of the components are missing.but In such case any of the reports from three should not open. Thank in advance. Please help me to solve this issue.

First of all thanks a lot. Now problem is In coding I have time filed which stores current time when there is some events happen. i wants to generate popup after(5 minutes) time reaches at time=time + 5minute. so after every 5 seconds in timer's tick event i am checking,Is time has reached the limit.if it is then generate popup. This is the coding which i am doing. if (System.DateTime.Now.ToShortTimeString() >= Actualtime.AddMinutes(5) ) { //Here Actualtime and all other variables are declared already. frm_grcprd_popup obj_popup = new frm_grcprd_popup(); obj_popup.lbl_Visitor_Id.Text = id[i].ToString(); obj_popup.Show(); } There are some more database operation is there to show values on popup. thats it.

I set interval to 5000(5 seconds) i think it's not small number. What u say?

Hello friends, I wants to generate popup in my windows application after every 5 minutes of some events. I am using Timer Control for that but i don't get accurate result and Continuous execution of timer ticks hangs the Computer. I have also tried make one service but it does not allow any user interface with that. i am very confused. Please help Thanks. RAHUL. E-mail:rahulpatel112@gmail.com

thanx DoctorMick. exactly as u r telling me. This Problem arise when i am using windows service. What i m doing,Access records from one table from local server.Store it in dataset and then i will go for inserting record to Remote server.But i am unable to connect to remote server.

Problem: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Request This problem is generate when i connected with remote server i want to connection between two server to transfer data from one table to another.and i got data froms local server but when connect to another server then this problem arise.. From Mr.Saunat Sharma