Hello Sir,

I am not saying that there's any problem with Label's Text with value
I wrote this because Alphard is using Query Builder which I don't think takes values from Label or TextBox.(I may...

no it is not possible there you have to specify the exact string or text instead of Label1.Text.

then please post the exact error. so that we can find out where the problem lies.

Hi Alphard,

may be becuase of last comma issue...
SELECT * FROM tblHeader WHERE Requestor='" & label1.text & "'"

tin
hint
in


sour

ring
grin
garnish
rain
grain
hair


My word: Stress

I admit my mistake at 9*2... :(
I really apologise for giving wrong suggestion.. Dunno how I went wrong..
yes it will be sqauring every tym num decreases by 1 :(

What you have done is :
num *= num;
num--;

which will do the following :
1. if suppose you entered 3.
num *= num will giv num = 3*3 = 9
then num-- i.e, 2
then it will proceed like:
9*2

Ok that's fine..
Its factorial of the number.
Use Kiryoku's example.
That might help.

Hi Demonisya,

The problem I guess is here in while loop.
What exactly do you want your program to do? to find the factors of the entered number or the Factorial of the number??

Thanks for the help...
That colon issue was causing the problem. using [] has solved the problem. Now I am able to update.

Thanks alot.
:)

Ohhh!!!
Actually I just did that because of space between the column names. May be I should try using []. Actually I am saving my column names as 'Serial No', 'Compnay Name', 'Branch' etc.
And my...

I have saved the column name as 'Serial No' with quotes also in the name,only beacause of the space issue. I have tried using sheet name as [AssetsLiabilities$] but that still cant update.

I am...

AssetsLiabilities is the Sheet name.

Dim DbConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & fpath & ";" & _
"Extended Properties=""Excel...

how have you placed checkboxes in GridView? using template feilds?

for Each gvrow As GridViewRow in GridView1.Rows)
Dim cb As CheckBox = (CheckBox)gvrow.FindControl("CheckBox1")
Dim chkstate As Boolean = cb.Checked
'perform ur...

Hi All,
I just don't know whether how correct my quetion is. But the problem i am encounterign while deveoping a website in ASP.NEt is that, when I run my website in IE it shows me the correct...

Hi All,

My update query refuses to update the data in the Excel sheet via OLEDB connection.
I am able to insert and retireve the records but could not update.
Though my syntax is correct and...

Add a template field in the datagrid edit columns field.
Then in edit template fields add the check box and assign the problem as needed

Do you want to connect to MSAccess or create an MSAccess form?

Hi plongx211,
show some of your effort first. :)

maxrow = ds.Tables("summary").Rows.Count
'counts the number of rows in the Table 'Summary'.

If maxrow > 0 Then
'CHECKS whether there is atleast one row in the table.(ie., >0)

Basically checks...

Hi All,

I want to update a row in existing excel sheet using vb.net where the row identification is according to the textbox text and the first column entry of that row in the excel. I just can't...

Hi All,

I need to change the style of the first row in an excel sheet(that is created dynamically) in VS 2008. I tried using Excel.Style in vb.net but cudn't seem it working.

any help?

what is simple coding??

I was able to export the data from database to excel using gridview but now the problem is how to append new values in the same existing excel sheet that i created earlier while exporting the data...

Hi Ana D.,
Please show your code first.

any help??

Protected Sub Button15_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button15.Click

Dim con As New SqlConnection(connection_string)
'Dim cmd As New...

Dim con As New SqlConnection(connection_string)
Dim sqlquery As String = ""
con.Open()


Dim dataExport As String = ""

...

no idea!!! :(

Corn oil is made from corn, Olive oil is made from olives, so what does baby oil come from?

(Source : iGoogle)

Hi all,
I just need an idea (not code) how to export data from my databse to excel sheet..that too row wise..
I only need a starting idea... m using Visual studio 2008.

Try Referencing this book....
B. Brey, Microprocessor Programming and Interfacing...

snap

son
pal
nose
rose
sole
plan
parse
alone
:
:

clap :D

Dictionary..ah yes!..Describes Many Words... but I can't find out the description of my name in the Dictionary :P

Why, don't you sleep??
Everyone Sleeps..Sleep is a natural and periodic state of rest during which consciousness of the world is suspended...


My Question:
Yes or No? :)