I have a tbale in database tow tables city and Intrest I need to calculate somethign like this
city1*intrest1 + city2*Intrest2 + city3*intreste3
final result I ned to asing in other column
My database is not allowing me to execute store procedure as perssion is denied by administrator. But I have to run a store procedure in my application, described below.
Can I replace this store procedure with "select query " on .net coding page i.e I want to make a function which will only select data from database and give the result same as this store procedure . store procedure-
CREATE procedure NEW_VIV
@user varchar(50),
@year char(50),
@month char(50)
[Code]....
I have a store procedure that retrieves several records, I need to create a "Save as file" button in order to export all this data in a external file such as: tab delimited or xls or csv.
Note: I don't use a gridview.
How can I achieve this?
I work with VS2008, C#, SQL Server.
I am trying to populate the textbox with store procedure results.I am getting the Error As Follows :
There is already an open DataReader associated with this Command which must be closed first.Here Storeprocedure i m using n my C# Code.
Store Procedure:
ALTER PROCEDURE GetAllHolidaysByUser(
@FirstName nvarchar(30),[code]....
I just want to display the results of store procedure by any means.I dont know who to populate Gridview using the store procedure by giving two input paramters.
how can i insert a gridview(multiple) record using store procedure.if record exist then it first Delete then Insert in a particular CRS_CODE.my table is below.
[Code]....
How can I call a store procedure from the other storeprocedures ?
View 3 RepliesI am using Sql Server 2005,My table structure is below.
Create Table ComentTable(id int,coments varchar(4000))
insert into ComentTable values(1,'sanjay I don%27t Know Tamil Language')
insert into ComentTable values(1,'sanjay I don%27t Know Kanar Language')
how to write storeprocedure update coments column replace %27 to '
I would like to write a function to reuse some functionality that I repeat over and over...
For example:
[code]....
What's changing, in every field, is only the lambda function to get the current field to edit (Name, City, Address, etc...).
What is the best method? Or better: is there ANY method to extract a generic function?
how can i use cursor in this function ?
ALTER FUNCTION [dbo].[GetCatIDChilds]
(
@CatID [code].....
[Code]....
How to write Grid view line in code behind using function
<asp:SqlDataSource ID="DS" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Products] WHERE ([ProductID] = @QSID)">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="" Name="QSID" QueryStringField="ID"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
I have a Listview which uses a StoredProcedure to display the data. That part works fine. What I'm trying to do is delete multiple lines using a different store procedure. So I did this code:
<asp:SqlDataSource ID="SqlDS_BasketDetails" runat="server"
SELECT 1000000*QuantityNC/Quantity AS PPM FROM [table1] However I need my WHERE clause to do thisI need the above calculation depending on BusUnit, which is linked to PartNumber, which is in the above table. also it has to be by Company (which is selected from a dropdown). And also based on the current month and year.
PartNumber and CompanyName are in [table1]
BusUnitID, PartNumber, SupplierID, are in tblParts
BusUnitID and BusUnit are in tblBusUnits
I need to call two dofferent javascript functions accroding to the value of a Databinder item.
<%
if
((DataBinder.Eval(Container.DataItem,
"account_type"))
== "Investor")
{
%>
<a
href="javascript:void(0)"
onclick="ViewInvestorDetail('<%#
DataBinder.Eval(Container.DataItem, "row_id")%>','<%=
BasePage.ServerPath %>')"
><h3><%#
DataBinder.Eval(Container.DataItem,
"account_username")%></h3></a>
<%....................................
[Code]....
and I want to call this Button2_Click from my code, what should I write as parameters of this function?
I have a simple class Employee that I would like to validate using attributes, but I'm not sure how to write the Validate function:
[Code]....
what my Validate function should look like?
I have a table with columns A and B, values as follows..
A B
-- --
1 11
1 12
1 13
2 21
2 22
2 23
i have a db with two simple tables:
tbl_events:
-Event_ID int
-Event_Name varchar
-Event_Organiser varchar tbl_events_organisers
-Organiser_ID int
-Organiser_name varchar
In event_organiser of tbl_events i want to store the organiser_ID's of the second table in an array, so a record in the first table will like something like:
-Event_ID=18
-Event_Name=My event name
-Event_Organiser= 15,31,109,21
I have something like the following in pages in two different projects, which saves to a DB with a LINQ to SQL operation:
[Code]....
One of the pages works with this code and the other doesn't. The only difference is that the project in which it does work employs a data control tool (ListView) and a custom profile provider.
I have 3 different databases where some tables are common.
View 16 RepliesI have TWO SQL tables (tbl1 and tbl2).
In tbl1 I am writing client's name, phonenumber. tbl1 also has auto increment column whose value is extracted by using SCOPE_IDENTITY.
Now here is the problem, I have DataTable "dtbl" which I have to write to tbl2, this dtbl can have any number or rows. What is the best way to write the whole dtbl to tbl2.Also I have to do RollBack if any error occurs. Here is the flow which I have to achieve..
System Status = CURRENT
*write clients to tbl1 (get Identity column value)
*write dtbl to tbl2 (in case of any error, rollback to System Status = CURRENT)
I have database code like this
try
{
string strConnectionString = ConfigurationManager.ConnectionStrings["SqlServerCstr"].ConnectionString;
SqlConnection myConnection = new SqlConnection(strConnectionString);
myConnection.Open();
string hesap = Label1.Text;
string musteriadi = DropDownList1.SelectedItem.Value;
string avukat = DropDownList2.SelectedItem.Value;
SqlCommand cmd = new SqlCommand("INSERT INTO AVUKAT VALUES (@MUSTERI, @AVUKAT, @HESAP)", myConnection);
cmd.Parameters.AddWithValue("@HESAP", hesap);.......
It works fine but what I want, in the catch function, is to call the javascript alert function.
I've tried this
Response.Write("<script language=javascript>alert('ERROR');</script>);
But there is an error
How can I show error message in javascript alert function?
to write function in C#
I need to write function for this algorithm.
SSCC
The check digit calculation uses the standard method. Suppose you want to calculate the check digit for ID number 10614141192837465.
Step One: From the right to left, start with odd position, assign the odd/even position to each digit.
Index
1
2
3
4
5
Digit
1
0
6
1
Position
odd
even
odd
even
Step Two: Sum all digits in odd position and multiply the result by 3.
(1+6+4+4+1+2+3+4+5)*3=90
Step Three: Sum all digits in even position.
(0+1+1+1+9+8+7+6)=33
Step Four: Sum the results of step three and four:
90+33=123
Step Five: Divide the result of step four by 10. The check digit is the number which adds the remainder to 10. In our case, divide 123 by 10 we get the remainder 3. The check digit then is the result of
10-3=7.
i have one table and structure of table is like.Now i need to fetch the Resturant Name and status of Resturant ( whether it is closed or open by comparing the opening time and closingTime with currentTime).
View 6 RepliesI have the following code which writes to a Gridview:
[Code]....
Using the same methods of connecting to the database, how can I amend this code to write the result of a second query (which only returns a number) to a label?