Search results for query: *

Hi, I have a table named tblemployee in the sql2005 database MyCompany. I am trying to create a page that have a textbox which user can enter an integer 1-3 (number of csv file)and a button when clicked, it will connect to tblemployee table, obtain the number of records of the table and divide...

I am sorry. I found out what my problem was. Thanks

Greeting, I have a gridview with checkbox that allow user to check to select and when the user is done selecting, he/she click on Submit button and will be send to a different page. below is the click event code Protected Sub Button2_Click(ByVal sender As Object, ByVal e As...

The value I need (which a paragraph of text)is in the SQL table and I do not know how to assign it to a text box from SQL. So what I did is create a SQL datasource and have a listbox to grap that value (text string) then copy it to the text box.

I have a listbox that display a select distinct field from SQL and I have a button when clicked, it supposed to copy the content of the listbox into a textbox, but it didnot, it seems like I have the select the value first then click copy. Is there a way to default it to automatically select the...

Hi I have a page with several radiobuttonlist, ddls, textbox a gridview that display data from SQL DB, and when I click edit button, it will send me to another page (update page) to update data. when I am done I click Complete, it will then close the update page and I am now back to begining...

Thank tperri for your help. I tried it, it worked but then I realize that Rows.Count does not change right away. What I mean is: I have a drop down list, when I select a name for example, the gridview will display information on the name selected, and when there is no info then it will display...

Thanks Jason for your help. Sorry I did not understand well your 2nd step. You mean to pass currentuserid as parameter to sql, right? But what do you mean by if record count comes back 0 return the user to "grid" page. Please can you give me a quick example, I am very new to sql and aspnet...

Sorry for the confusion. Let me try again. I have a sql db table named Billing as this: Account# Address UserAllow --------- -------- ----------- 9873546 XYZ domain\johns 7585747 RST domain\maryf Now let say john open the page Update.aspx...

Hi all, I have a page that capture the userid and assign it to session("currentuserid"). This current user can only update records in a sql Billing table that UserAllowed id field of that record match the session("currentuserid"). Now my question is how can I assign UserAllow id to a...

Hi everyone, I have a form page in ASPnet when the Submit button is clicked, a stored procedure in SQL is called and the pararmeters of data in this form (such as first and Last name and so on) will be passed and inserted into a SQL table of a UserInfo DB. Here is a segment of code in the...

Yes, That was exactly what I was looking for. Thanks PH

Hi, I am currently learning Access DB. I created a form with a button when clicked it will open another form. My question is when it open the second form, it default it to Form view, how can I change it to default to Datasheetview? Here is a few lines of the codes attached to the command button...

Hi, I am trying to create a column that displays number reflecting the row number and because of reflecting the row number the digits in the cells are automatically changed at any time a row is inserted or deleted. For ex: Rows 1-5 are headers F_Name L_Name...

Happy Holiday season to All, I am very new to SQL server. I have a SQL 7.0 DB that has a file property set to file automatically grow by 1 percent and so is the transaction log. My question is can I change the growth to 1 MB by selecting the "in megabytes" option? will it hurt anything? Thanks...

Good Morning. I have an Excel sheet with all columns formatted (text or number or date...). It was working fine until a user did something to it and now one of my column which is shown with format: number 2 decimal places but when I enter 1.00 it will automatically default to 1 but if it's 1.05...

Hi Skip, I think I got this working and this is what I have: Private Sub Worksheet_Change(ByVal Target As Range) If (Target.Column = 2) Then If (Target.Value > 0) Then If (Cells((Target.Row), 1) = "") Then MsgBox "Input Date" End If End...

I am sorry. I tried but was not successful. I have so little knowledge on VBA, and was unable to get the syntax correctly. Could you please show me more detail. Thanks!

Greeting to All, Question 1) I am trying to implement something like this: I have in Column A as Date and Column B as Quantity. Date Qty 07/25/05 1 if a user enter a number in the Qty field and go to different cell and left the Date blank, a message should pop up and ask the...

Thanks Phil & Skip! That what I needed to do