Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About betul

  • Rank

Profile Information

  • Gender
  1. Hi everyone, I have a photo upload form and I upload photos to disc D to prevent insufficient space problem. While uploading, following code stores the image under D; img.Save(System.Configuration.ConfigurationSettings.AppSettings["Server"].ToString() + filename); in web.config;<add key="Server" value="D:/Photos/"/> but when I try to read the image with the code below, image is not displayed; imgDetail.ImageUrl = System.Configuration.ConfigurationSettings.AppSettings["Server"].ToString() + red["PhotoName"].ToString(); Now, on aspx page I try ; <img src="D:\Photos\3000.jpg
  2. thank you very much for the script. these were my attempts to create the variable, althought it looks reverse because placing var eleToHide=window.document.getElementById('<%# DataBinder.Eval(Container.DataItem, "id")%>') at the top of your script does not work, that's why I tried it with onload() and oninit() functions and I was going to return the function "firstHide" to the variable. anyway, I also tried it this way; <script type="text/javascript"> function showHide(ele){ var eleToHide, eleToShow; if(eleToHide){ eleToHide.style.display = "none" }; eleToShow = document.getE
  3. ok, I tried saving the element with onload and oninit functions, but nothing happened. First I tried this;in aspx;<a href="#" class="BlackButton" onload="java script:firstHide('<%# DataBinder.Eval(Container.DataItem, "id")%>')" oninit="java script:firstHide('<%# DataBinder.Eval(Container.DataItem, "id")%>')" onclick="java script:showMe('<%# DataBinder.Eval(Container.DataItem, "id")%>')">in javascript;function firstHide(item){ var i=document.getElementById(item); i.style.display="none";}that didn't work. assuming onload() works only in <body> tag, <body
  4. Thank you, but how will I save the dynamic ID to a variable?
  5. Hi,I have a dynamic datalist and a JS function as below. When the link in the datalist is clicked, it calls the JS function and shows the row underneath it. If I click on a second link I want the first row disappear but I can't do it because the row id is dynamic. Could you please help me? Any help will be appreciated.Datalist; <asp:DataList ID="dlQuestions" runat="server" Width="607"> <ItemTemplate> <table width="607" cellspacing="0" cellpadding="0"> <tr runat="server"> <td width="15"> </td> <td val
  6. Hi,I want to send e-mails to bunch of e-mail addresses stored in sql server. My procedure is ready but because there is no database mail option on the express edition, it is not working . Any suggestion is appreciated.Thanks.
  7. That works perfect. Thank you sooo much.
  8. Thank you, I've tried but I get this error;Msg 102, Level 15, State 1, Line 18Incorrect syntax near 'temp'.
  9. Ok, I've changed the procedure like this; ALTER PROCEDURE [dbo].[GetActivePeriod]ASselect w.WorkKeeper, DATEDIFF(ss,a.ProcessDate, MIN(b.ProcessDate)) AS 'ActivationPeriod'FROM Work w ,ProcessLog a INNER JOIN ProcessLog bON (a.ProcessId < b.ProcessId)WHERE CONVERT(varchar(10),a.ProcessDate,111) = CONVERT(varchar(10),GETDATE(),111) AND a.ProcessName=1AND CONVERT(varchar(10),b.ProcessDate,111) = CONVERT(varchar(10),GETDATE(),111) AND (b.ProcessNum=2 OR b.ProcessNum=4 OR b.ProcessNum=5 OR b.ProcessNum=6) AND a.WorkId=w.WorkId AND b.WorkId=w.WorkId GROUP BY w.WorkKeeper,a.ProcessDate And th
  10. Hi all,I have a procedure as below; ALTER PROCEDURE [dbo].[GetActivePeriod]AS SELECT w.WorkKeeper, SUM (DATEDIFF (ss, a.ProcessDate, MIN(b.ProcessDate) ) ) AS 'ActivePeriod' FROM Work w, ProcessLog a INNER JOIN ProcessLog b ON (b.ProcessId > a.ProcessId AND b.WorkId=a.WorkId)WHERE CONVERT( varchar(10), a.ProcessDate, 111) = CONVERT( varchar(10), GETDATE(), 111)AND CONVERT( varchar(10), b.ProcessDate, 111) = CONVERT( varchar(10), GETDATE(), 111)AND a.ProcessNum=1AND ( b.ProcessNum=2 OR b.ProcessNum=4 OR b.ProcessNum=5 OR b.ProcessNum=6 )AND w.WorkId=a.WorkIdGROUP BY w.WorkKeeper And I get
  11. I changed the select statement as; SELECT * FROM Work (nolock) w LEFT OUTER JOIN (SELECT DISTINCT WorkId FROM Files WHERE FileName LIKE '%' + @FileName + '%' OR FileTitle LIKE '%' + @FileName+ '%' OR @FileName is NULL) AS f ON w.WorkId=f.WorkId and it works without repeating the rows.
  12. Hi everyone, Below is my procedure for the Work and Files tables. It searches the records matching the given parameters. However, if a Work has a few Files, the same "work record" is repeated as many as the number of files. How can I stop it? Thanks. set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[SearchWork] @StartDate DateTime,@EndDate DateTime,@Type int,@FileName nvarchar, AS SELECT * FROM Work (nolock) w LEFT OUTER JOIN Files f ON w.WorkId=f.WorkId AND (f.FileName LIKE '%' + @FileName + '%' OR f.FileTitle LIKE '%' + @FileName+ '%' OR @FileName is NULL)WHERE ((w.WorkOpe
  13. betul


    For the ones who have the same question, I've found a cute datepicker that can be added to VS toolbox. Here is the link; http://www.basicdatepicker.com/BDPLite/
  14. betul


    Hi,I need a pop-up datepicker to place in the forms. After a long search I found couple of them but they are not working in the forms with runat="server" attributes. Any suggestion is appreciated.Thanx.
  15. betul

    Editor For Articles

    thanks vestanbul.
  • Create New...