jasjit jas wrote:

insert date in a textbox from a calender calender

under Calendar1_SelectionChanged event write this snippet textbox1.Text = Calendar1.SelectedDate.ToString(); hope this helps Regards, SunilWise

omlac wrote:

http://localhost:2942/Website/frmAddUsers.aspx and access it, Does anyone know how to stop this.

i can see that you are running your application from the filesystem it is not running from IIS. To avoid this you should create virtual directory for your application. if you have done this already. In visual studio open your project from LocalIIS and select the related virtualdirectory(i.e., your application). before running your project in IIS select your VD properties and add the default page as frmAddUsers.aspx this might solve your issue Regards, Sunilwise

Civic06 wrote:

now there is a problem because the path is this: abc/admin/admin/Admin.master which obviously doesn't exist. i can modify the MasterPageFile but it causes a problem when i want to compile and debug on my local machine.

i think u have created second virtual directory under admin folder.The second VD you should create under VD abc Regards sunilwise

first, create virtual directory for abc by right-clicking on the default website in your iis. here in documents tab move default.aspx to top. Then right-click on the virtual directory abc which you have just created and select new--> virtual directory-->alias name admin-->give tha path and so on. right click admin VD to select properties in the documents tab move default.aspx to top this may help u Regards sunilwise

no probs i got the solution i modified my query to string sql = "select format([dateregistered],'MM/dd/yyyy') as Dates,[user],[client facility],sum([payroll score]) as LC from [sheet1$] group by [user],[client facility], format([dateregistered],'MM/dd/yyyy') order by [user]"; its working for me.......... ;) ;)

modified on Monday, December 1, 2008 4:54 AM

sunilwise wrote:

string sql = "select CONVERT(varchar ,[dateregistered],103) Dates,[user],[client facility],sum([payroll score])LC from [sheet1$] group by [user],[client facility], CONVERT(varchar ,[dateregistered],103) order by [user]";

no probs i got the solution i modified my query to string sql = "select format([dateregistered],'MM/dd/yyyy') as Dates,[user],[client facility],sum([payroll score]) as LC from [sheet1$] group by [user],[client facility], format([dateregistered],'MM/dd/yyyy') order by [user]"; its working gr8 for me

Hi frns,

select CONVERT(varchar ,[regdate],103) Dates,[user],[client facility],sum([payroll score])LC from [sheet1$]
group by [user],[client facility], CONVERT(varchar ,[regdate],103) order by [user]

i am programatically retreving data from excel sheet. for retriving data from excel the query i have written is the above but it is giving me error. the error is :Syntax error (missing operator) in query expression 'CONVERT(varchar ,[regdate],103) Dates'. How to use the convert function in excel query regards sunilwise

modified on Monday, December 1, 2008 4:53 AM

Hi everyone, i am developing one application in that i need to get data from excel sheet to the dataset after that i'll have some calculations to do. In the excel sheet i have one column [dateregistered] the date format in that column is (mm/dd/yyyy hh:mm) i want the date format to be (mm/dd/yyy) from sql query. i have written a query below which is giving me error

Syntax error (missing operator) in query expression 'CONVERT(varchar ,[dateregistered],103) Dates'.

here i am getting the data directly from excel sheet not from sql server so i want know how to use convert function for retriving data from excel sheet string sql = "select CONVERT(varchar ,[dateregistered],103) Dates,[user],[client facility],sum([payroll score])LC from [sheet1$] group by [user],[client facility], CONVERT(varchar ,[dateregistered],103) order by [docQscribe user]"; da = new OleDbDataAdapter(sql, con); ds = new DataSet(); da.Fill(ds,"Table1");

Hi all, My PC has Intel DG33FB MotherBoard and core 2 duo Processor 2.53GHz with 2GB transcend RAM. I have installed XP in my system. Later i installed windows 2003 server as 2nd OS. My problem is for Windows 2003 server the graphics and audio driver are not getting installed. Can anyone help me in this regard Regards sunil

Hi all, My PC has Intel DG33FB MotherBoard and core 2 duo Processor 2.53GHz with 2GB transcend RAM. I have installed XP in my system. Later i installed windows 2003 server as 2nd OS. My problem is for Windows 2003 server the graphics and audio driver are not getting installed. Can anyone help me in this regard Regards sunil

you can execute sp_help or 1.you can type the table name in query analyzer 2.select the table name and press alt+f1 keys this works fine for me hope this helps

i am involved in a project in which i have to check the browser installed activex controls. this check has to be performed by the browser itself. can anyone suggest me how to do this. thanks in advance

can anybody tell me how to transfer a session from asp page to the asp.net page if possible with example thanks and regards sunilwise

sir can you please tell me in detail how to handle the event

i am using grid view control in my project i have set autogeneratecolumns false and added columns like this <Columns> <asp:TemplateField HeaderText="User Name" SortExpression="UserName"> <ItemTemplate> <%#Eval("UserName")%> </ItemTemplate> <ItemStyle HorizontalAlign = "Left" /> </asp:TemplateField> <asp:TemplateField HeaderText="Voice Id"> <ItemTemplate> <a href="javascript:DispalyError('<%#Eval("vid")%>','<%#Eval("UserType") %>')" title="<%#Eval("VoiceId")%>"> <%# Eval("VoiceId") %> </a> </ItemTemplate> <ItemStyle HorizontalAlign="Left" /> </asp:TemplateField> (more columns) now i want to have sorting property for all columns in the grid can any body please tell me how to do this regards sunilwise

in web.config: <appSettings> <add key="ConnString" value="server=(local);database=Northwind;Integrated Security=SSPI" /> </appSettings> call in u r web page as Imports System.Web.Configuration dim constr as string constr=ConfigurationManager.ConnectionStrings("ConnString").ConnectionString use this hope this helps

i am having one gridview in my application where i am displaying one linkbutton column in it. By clicking on the link some xxxx.wav will be downloaded and directly played in the media player. Code: <%# Eval("FeedbackTitle") %> what i want is, to show some xxx.gif image to the user at the time of downloading it will be useful for larger files. if anybody has a solution for this please do let me know. with warm regards sunilwise:)

i am having one gridview in my application where i am displaying one linkbutton column in it. By clicking on the link some xxxx.wav will be downloaded and directly played in the media player. Code: <%# Eval("FeedbackTitle") %> what i want is, to show some xxx.gif image to the user at the time of downloading it will be useful for larger files. if anybody has a solution for this please do let me know. with warm regards sunilwise:) -- modified at 0:08 Saturday 1st December, 2007

Nobody has sent me the solution for the question which i was asking from yesterdayhttp://www.codeproject.com/script/comments/forums.asp?msg=2332286&forumid=12076#xx2332286xx[^] Anyway no problem mates i got the solution in the code project itself in the link http://www.codeproject.com/aspnet/JavaRowSelect.asp[^] i am posting this message because this may be helpful for some others in future regards sunilwise:):laugh::):laugh:

i have posted a query yesterday plz look at it someone and help me http://www.codeproject.com/script/comments/forums.asp?msg=2332286&forumid=12076#xx2332286xx[^] regards sunilwise