dotNetDummi

Hi all, I want to retrieve some data from the database and return as a datatable. However, it does not work. I tried both methods that I could find in the Internet, but it's not working. May I know what have I done wrong? The datatable is returned as null …

Hi all, Is it possible to insert a SQL statement where I specify the time, and not the date. I do need the date, but I want it to be the current date when I run the insert statement. The time got to be fixed. For example, Insert into xxx …

Hi, I need to create two tables in a Ms Word because I have two gridviews. But the output became "table in table". How can I "separate" them ? [CODE] Word.Table wt1 = oWordApp.Selection.Tables.Add(oWordApp.Selection.Range, GridView1.Rows.Count + 1, 2, ref missing, ref missing); Word.Table wt2 = oWordApp.Selection.Tables.Add(oWordApp.Selection.Range, GridView2.Rows.Count + 1, 7, …

Hi experts, I've been researching about convert an aspx to pdf but nothing seems to help me. I found crystal reports but my layout is not just gridview only. In my aspx, it includes textboxes, labels, tables, gridview. I need to print them to a pdf format automatically. Due to …

Hi all, I'm new to VB and I am doing a lottery program. I managed to produce 7 random numbers but I am stuck with the sorting. All I can think of is to use if statements to do comparsion, but that will be a long way to do it …

Hi all, I'm working on a multimedia player with VB6 now. I have reached to a stage where my media player can play and stop music that I have selected, but path and file name are english characters. how can I play files that have chinese characters for their file …

I am working on a web-based app, and I need to implement a function whereby it checks the dates daily, and send reminder email automatically. May I know how can I do that? I saw some websites that mentioned about Console Application and Windows Scheduler. Is that what I need? …

Hi experts, I used Window.showModalDialog to open comment.aspx. I need to disable the X button(top right button of IE) in my comment.aspx as entering comments is compulsory. I've done several days of research but to no avail. I'm guessing that it's not possible even if I use javascript. Any ideas …

Hi experts, I have a project working on C# and ASP.Net. There's a function for my users to delete a project by the project name, which is the primary key. However, it is not functioning perfectly. When the project name is two word(second word more than 4 characters), it could …

Hi experts, I have a problem with downloading file. Okay, my project is setup in IIS (pointing to the folder in my desktop) and my users are able to login, upload a file into the folder. However, they are not able to download the file (except me). How can I …

Hi experts, I have a task to print some data into a word document .I need to set the word document to readOnly. It's working but user still can edit. Is there any thing I can do whereby user cannot edit the document? [CODE]// Word.ApplicationClass oWordApp = new Word.ApplicationClass(); // …

Hi all, I have a gridview in my project. There is a cell that contains a dropdownlist, textbox and button. My task is when the use clicks "others" in the dropdownlist, the textbox and button should show so that they can add new value into the dropdownlist. But I got …

Hi experts, I need a linkbutton/button to download the files which my clients have uploaded. Below is my upload method and it works. [CODE]protected void uploadFile() { String projectID = (String)Session["projId"]; //change the file name if (!FileUpload.FileName.Equals("")) { // Create a new folder in Docs folder (folder name = projectID) …

Hi experts, I need a validator in my gridview. When the user update a field in the gridview, I need to check if the email is valid. How can I do that? Below is my gridview. Please help. Thanks! [CODE]<asp:GridView ID="gv_retrieve" runat="server" AutoGenerateColumns="False" CellPadding="3" ForeColor="Black" GridLines="Vertical" Width="751px" OnRowEditing="gv_retrieve_RowEditing" OnRowUpdating="gv_retrieve_RowUpdating" onRowCancelingEdit …

I've two tables where their composite keys are foreign keys that references each other. table1 (projId, userId, name, add) table2 (projId, userId, status, responseDate, reason) I need to retrieve table1(name,add) and table2( status, responseDate, reason) with projId only.. my query is [CODE]Select ap.name, ap.add, p.status, p.responseDate, p.reason from table1 ap, …

Hi all, (I apologise if this thread is out-of-topic) I need some ideas for my project. I have to develop a web application for some users to approve some documents. The problem I have is that I [U]can't[/U] give these people a login account (due to my project requirement). I …