Hi,
Does anyoe know how to call the F9 key function (Calculate Sheet) using C#?
Thanks.
NiteshR
Last Activity: Jul 20 '07, 01:17 PM
Joined: Mar 8 '07
Location:
-
Calling F9 function in Excel
-
hi,
i joined the two tables using a right outer join and insert those values into a new table.
i then joined that table using a right outer join to give me the output i required.
thanks.... -
Passing Parameter Using 'IN'
Hi,
I want to pass a variable to a sql query using 'IN' instead of '='.
eg.
WHERE (Name = @param)
id like to do the same thing using a IN
e.g.
WHERE Name in @param, @param2
What is the correct syntax to do this, and is this even possible.
Thanks. -
Hi, try 1 of 2 things,
1.
On the enterprise manager, make sure you are added as one of the users for that specific db.
2.
If you are not the creator/owner of the
eg.
SELECT *
FROM owner_name.tabl e
thanks....Leave a comment:
-
Ok, I understand what you mean by this.
The only way i think i can overcome this is by inserting a if..else statement within the sql query, maybe by creating a stored procedure.
Any ideas on this?
Thanks....Leave a comment:
-
Thanks for the help.
I used the code you sent me, but it still doesn't output all the null values.
The only output are those which are greater than 0.
Is there anything else i can use to do this? eg. a if..then statement in sql...Leave a comment:
-
SQL Display Null Values
Hi,
I am using C# code to retreive values from a table in sequel.
This is done using a join between a table containg values and one using dates.
The problem is that I am unable to retrieve a value for days where there is no value. I would like to return a 'NULL' value or even a ' 0 ' value if no amount is found for that specific date/day.
SELECT COUNT(*) AS Expr1
FROM db.sales_month RIGHT... -
DataRow Array
Please Help!
Hi, iv been struggling to figure this out for some time now.
Im using visual studio 2005(C#).
I want to declare an Array (Pre-defined) of datatype 'Datarow'.
The code gets a value from a table and outputs the value to a cell in MS Excel.
My code is as follow:
//
DataRow a = dt.Rows[0];
oSheet.Cells[1,1] = a[0].ToString();
DataRow b = dt.Rows[1];... -
Declare Looping Variable
Hi,
I want to declare a variable outside a loop.
The variable then needs to change everytime it runs within the loop.
example:
DataRow name;
//Once in the for loop, the variable name must change to
name1 then name2, name3, name 4 and so on..
How do i do this? -
Accessing COUNT(expr) values
Hi.
When i write a SELECT statement that returns a table with values, I am able to access the value individually using C#.
When i write a SELECT statement that uses a COUNT(expr), I am unable to access the values individually even after using a ORDER and GROUP BY.
Please assist. -
Looping Through SQL Values
Hi, Please Help.
I am writing a program that displays retrieves values from a SQL table and displays it. The Table contains a single column with many rows.
I am able to retrieve the first record, but not the rest.
I understand that I have to use a looping structure to do this.But I do not how to.
My SQL code is as follows:
SELECT COUNT(daily_mon th.card) AS Expr1
... -
SQL Loop Using C#
Hi,
I am currently writing a program that calls a SQL query within C# and outputs value to cells within excel.
I am using (C#) visual studio 2005 and sql server 2000.
The query returns a single column with many values containg +- 30 rows.
Once this statement is called and output using the below statement:
[B]string Name = this.Monthly_Na mesTableAdapter .getName().ToSt ring( );
oSheet.get_Rang e("A1",... -
Looping through SQL Data through C#
Hi,
I am currently writing a program that calls a SQL query within C# and outputs value to cells within excel.
I am using (C#) visual studio 2005 and sql server 2000.
The query returns a single column with many values containg +- 30 rows.
Once this statement is called and output using the below statement:
[B]string Name = this.Monthly_Na mesTableAdapter .getName().ToSt ring();
oSheet.get_Rang e("A1",... -
Hi, this doesnt seem to work.
when i output the value from the variable 'myq', it shows me the coding text
as typed....Leave a comment:
-
Writing SQL Code in C#
Hi,
Will someone please help me with this.
I am using Visual Studio 2005 (C#).
I would like to write SQL queries in my code and assign it a variable thereafter.
Would someone please help me with this urgently.
Thanx. -
Updating Excel using C#
Hi,
I am developing an application that is required to update excel spreadsheets which currently take over to update. I need to create an application using C# and it needs to call the function already created in excel. How would I do this?
Would calling these functions through C# speed up the process or will it take the same time to update?
Should i rather write statements within C# to do the calculations or should I call the... -
I figured it out,
its Application.Res et
Thanx!...Leave a comment:
-
Reseting Application
Hi,
I Need help urgently with this.
I need to be able to reset my application once i've pressed a button on my form.
The entire application needs to reset, just as when I press the play button on C#.
I cant use form hide, show or close.
Is there any way i can reset my entire application? -
Leaving a line c# 2005
Hi,
How do I leave a line when inputing into a multi-line textbox.
I would like to add text to the textbox, but on a new line.
In VB you use '\n' i think.
Here is my code:
if(a < 0)
{
txtName.Text = "Hello";
// Want to add a name after the word 'hello', but on a new line
... -
the app stores data in a table in sql server via user input and retries data from another table using validation based on the input.Leave a comment:
No activity results to display
Leave a comment: