how to write sql query to retrive data as follows....
've a table with two columns..
brno brname
100 hyd,hyderabad
102 cni,chennai
03 mm,mumbai
104 kalk,kolkata
Suppose we want to select the data from the database then we write the query for that. Example:
SqlConnection con=new SqlConnection(Connetion name) string selectPkId = @"SELECT PK_ID FROM TABLE" SqlCommand cmd=new SqlCommand(selectPkId ,con);
So,my question is that why we basically use @ before the sql query.If I don't use @ before that then it again work fine (does not give any error), then what is need of using "@"?
I have couple of DDL's which let user choose couple of different values from it. Once the user has made his selection he clicks on the "Submit" buttion which redirects the user to the other page, which then displays table from backend SQL DB. The pages are named Page1.aspx and Page2.aspx resp. I am using Querystring to carry forward the values of the DDL's to Page2.aspx.
How can i modify the query in such a way that even if one of the DDL's is left blank the Query would ignore that and shall produce the table considering value of DDL2 in the where clause. In case both the DDL's are empty then the query will not have a where clause and shall showcase the complete table as such. I've written a query for this but it's not working the way it shoul.Here is my code for the SQLDataSource: [Code]....
I have created one class as Employee.
Then i created properties, as below
[code]....
and same properties to be used while retriving data from sql server.
I want to create a temp table to store data in a stored procedure and then then retrive it from the code.
I need to save the data in the begining before it is deleted.And then after the inserts are done I want to update the tblcontactlist by referring to the temp table.
[Code]....
i'm trying to issue a select command in my app soi could execute the command and retrive the data into a string variable.the problem is that this command is overloaded with DataSourceSelectArgument and i can't figure out what it is.i'm using sql server express and when issue a n insert command for example sq.Insert(); i have no problems.this the command that's holding me:
SqlDataSource sq = new SqlDataSource();
sq.ConnectionString = ConfigurationManager.ConnectionStrings["CustomerDatabaseConnectionString1"].ToString();
sq.SelectCommandType = SqlDataSourceCommandType.Text;
sq.SelectCommand = "SELECT * FROM CustomerTable where customerID = 1";
string result = sq.Select(some overload that's stopping me);
How I can write following SQL query using LINQ. There is no default constraint define for the ID column so we have explicitly pass the NEWID().
I want to replicate the products of a company to another company.
Insert Into Products Select NEWID() AS ProductID, ProductName, CompanyID = @DestinationID, ProductCategoryID From Products Where CompanyID = @SourceID
Also once I get these result how can I use InsertAllOnSubmit to insert all the records at once without looping it.
SQL query:
I have a hierarchy structure like:
B reports to A
C reports to A
D reports to A
E reports to B
F reports to B
and so on......
So, when A logins he should be able to see B,C,D(who are reporting to A) and also E,F(who are actually reporting to B and not directly to A)Please help to write such sql query.
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 two tables and following are the structure of both the tables
Tbale 1
Field1 Field2 Field3
d1 01 26/03/2011
d2 02 26/03/2011
d3 03 27/03/2011
Table2
Field1 Field2 Field3
01 6.15 14.25
02 7.30 16.25
03 6.00 18.25
My expected output when i search records by table1.field3 (say 26/03/2011)
Tbale 1
Table1.Field1 Table2.Field2 Table3.Field3 Table2.field2 Table2.Field3
d1 01 26/03/2011 6.15 14.25
d2 02 26/03/2011 7.30 16.25
d3 03 27/03/2011
Inorder to get the above result, what query should i write?
I need to write a query as follows which will be bound to a grid
select top 25 * from ErrTable Order by DateErrorad Desc
However, I need to write this query to return only 25 records at a time, but when a user clicks next it will display the next 25 most recent records from the db.
i am creating dynamic text box and dropdownlist on one DropDownList7_SelectedIndexChanged event like this code
[code].....
i am having a problem on my aspx page, what i did was i wrote a simple url re-wrte rule in my aspx page, after i write my url re-write rule my query string looks like this [URL] idea been to writing a rule to accept that above query for user friend seo url string, but when i am in that page i cant click any of my datalist page indexes ...it will redirect to [URL] i dont know how to fix this proble, i am trying s hard ,but i cant make it work, i think page post back changing my url re-write link.
View 2 RepliesBeing new to Linq and Entity Framework, I find myself struggling to write queries that are relatively simple in SQL. My latest challenge is how to write a query that pulls records from a master table and includes a column for aggregating data from related detail records. Let's start with this example:
List<Customer> list = (from x in Customer select x.Customer_ID, x.CustomerName).ToList();
Now I'd like to modify this so that I include a column indicating how many orders each customer has, where there is a one-to-many relationship between the Customer and Order entities. I suspect the solution might result in a List of an anonymous type rather than the List of Customer like my example, but that would be
I 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?
Need to figure out the correct way to do a simple SUM function in Linq, but also manipulate one of the feilds coming back by doing a Substring on it, here is the original SQL query:
[Code]....
i want to write query in run time in SSRS.is it possible??...
View 1 Repliesi have a table for customer forecast with following fields.. customer, year, week, quantity. now i need to write the SP to retrive the records based on the from week,year and to week,year... like this... from 45th week of 2009 to 25th week of 2010. how can write the query...
View 4 Replieshow do i write my alter schema query in Asp.net
using the sqlclient object..
I am developing asp.net mobile application. I am using XML as a database. I am querying on the XML to access the required elements & attributes by using LINQ to XML in .net. I have the follwing part in my XML file.
[code]....
The similar logic I need for the above defined XML part. In the above XML I want to write the LINQ to XML query which can access the NAME attribute of the 'VALVE' node (<VALVE NAME="PWV">), then it should access the text between 'DISPLAY-NODE' (<DISPLAY-NAME> Production Master Valve </DISPLAY-NAME>), & then it should access the all the attributes of the 'COMMAND' node dynamically ( <COMMANDS USE-TEMPLATE="TRUE" TEAMPLATE-NAME="ValveCommands.xml"></COMMANDS>). All these I want dynamically without explicitly specifying the name of the child node as well as name of their attributes ( similar to the way I written the above query ) Can we write such a code by using LINQ to XML ? It will be better if we can write code for above issue in a single logic ( similar to the way I written the above query ).
Suppose I have one table called [Code]....:
[Code]....
I want to see the specialist name and his jobs IDs horizontally.
[Code]....
A specialist may have
[Code]....
jobs. Suppose specialist
[Code]....
has 10 jobs where BEN has 5 jobs.
In this way I want to show specialist his jobs horizontally where the number of jobs may vary per specialist.
How can I do this in SQL?
How to write select query to get counts in row values
View 6 RepliesI have 5 radiobuttonlists and 5 checkboxlists and all are the product parts.I have table parts this values:
polecart_parts
productid
productname
productgroup
productvalue
productprice
sku
description
All radiobuttonlists and checkboxlist popluate from the database.comapring product productgroup and productvalue.after customer seleted items from these radiobutton list and checkboxlists iwant to create it as record to sttore in diffrent table with the all selected item + total price.so that in future we just serch record and we get it with and induval price and total price and seleted item.also its show image on selted items too.I dont know how to do it , I have MS ACESS database.I am using C# asp.net.I am working on it since last week.I dont know how i start it. I want to show image when it retrive the record which is customer seleted.
i have a table for customer forecast which contains customer, week number and quantit as columns. now i need to write query and list the week as column for each customer and each cell should have a quantity. how to write query for this using pivot logic. i dont want to use cursor.
View 3 RepliesI use asp.net 4 + c#,I have a GridView with many rows.When a User click the EDIT button in GridView I need to retrieve a Control in that specific row (now in edit mode).This Logic should work on GridEvent_RowUpdatingAt the moment my code (wrong) look inside every Row, so the Control founded is not unique and I receive an error.
// Event handler
protected void uxManageSponsoredContentsDisplayer_RowUpdating(object sender, GridViewUpdateEventArgs e)
// My code (Wrong!!!!):
foreach (GridViewRow row in uxManageSponsoredContentsDisplayer.Rows)
{
TextBox uxStartDate = (TextBox)row.FindControl("uxEffectiveStartDateInput");
}
Hope my question is clear. Solution:
TextBox uxStartDate = (TextBox)uxManageSponsoredContentsDisplayer.Rows[e.RowIndex].FindControl("uxEffectiveStartDateInput");