I'm using this code for creating and xml file out of a SQL2005 table:
[Code]....
Is there a way for me to create multiple xml files, one for every row, going by the primary key column, or do I have to create a separate query for each row?
I would also wondering what is the syntax for transforming this query into a stored procedure
I am facing a situation wherein i have to ask the user for the files to upload and save them as blob in the database. I have a single file upload control on the page and user can add as many files as he wants. When the user browse the file and click add button then the file gets added at some temporary location on the page and later on when the user has specified all the files to upload then I would like to insert all these files using a single insert query in the database.
View 2 RepliesI have to insert a multiple records under the single table.So i have to execute the command in the frontend for every records.
Inorder to avoid i write the query like this
insert into table1(field1,field2) values('1','Test1'),('2','Test2');
and also i tried
insert into table1(field1,field2)
SELECT "1","Test1"
Union all
SELECT "2","Test2"
But I am getting syntax error.
How to insert a multiple records under the single query?
I would like to use ASP.net, C# and SQL to display a list of games with radio buttons like below (the x is the radio). One team can be selected for each game.
game 1: x team 4 x team 2
game 2: x team 6 x team 1
game 3: x team 5 x team 3
The game list is stored in a table in an SQL database. So far, I can pull all teams into one big RadioButtonList. I cannot figure out how to create multiple RadioButtonList controls from this single table of games. Does anyone know how this can be accomplished - or reference to an example / tutorial that accomplishes something like this?
I would like to make a "select" from an Access (mdb) file in SQL Server 2008 R2. I was using:
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','C:..FILE.mdb', 'SELECT * FROM Users')
But I´m getting the error: Msg 7308, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
We need to upload multiple files using ASP.Net in one go. One option is to use the ASP.Net FileUpload control but it seems that it can't upload multiple files in one go. Any other option or ASP.Net FileUpload control can do multiple uploads in one go with some tuning?
View 2 RepliesI have a question which is insert multiple rows in a single insert? Is that possible?
For example:
INSERT INTO EMPLOYEE(NAME, AGE)
VALUES
(JAN, 18),
(JEN, 20),
(JIN, 23)
Using C#
I have code, something like I ask but there's an error.
Here's the code
string sql = "INSERT INTO EMPLOYEE(NAME, AGE) VALUES";
for(int i = 0; i < data.length; i++)
{
sql += "(@name" + i.ToString() ", @age" + i.ToString() + "),"
}
sql = sql.Remove(sql.Length - 1);
cmd = SqlCommand(sql, con);
cmd.ExecuteNonQuery;
I got an error of "Fatal error encountered during command execution."
The error goes here
{"Parameter '@name0' must be defined."}
How to upload multiple images on single button click....
View 1 RepliesI had implemented FileUpload code. In which for every particular Id, it creates Folder/Directory (if not exist) on Page _load.Then inside that particular Id's folder it will upload single or multiple files.
HTML:
<asp:Label ID="LFileUpload" runat="server" Text="Upload File"></asp:Label>
<asp:FileUpload ID="FileUpload1" runat="server" Width="300px" AllowMultiple="true"/>
<asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="UploadFile" ValidationGroup="none"/>
<asp:Label ID="LMsg" runat="server" Text="" Visible="false"></asp:Label>
[CODE]...
I have reffered the Select and Upload Multiple Files Gmail Style using JQuery and ASP.Net to upload multiple files but i want to upload files in button click. how can i call the code in button click because above mentioned article uploads the file using upload .ashx?
View 1 RepliesI Pieces
NA 400
I am used to making separate Business Object and List<> classes for my DB tables. Sometimes I just have a basic task in hand as displaying a list of year for a search box or having some values in a drop down.
Right now I am ending up with a lot of separate classes and List classes<> for these basic operations.
How can I make a single class for some basic tasks as these by using generics? I want to have single class for some methods like get current year, employee names, Department Name/Code, Title etc. I am using .NET 2.0.
Edit
After some searching, I found that I can achieve similar tasks by creating a DTO namespace.
What I don't get right now is how to create multiple classes inside my DTO class. Say 1 class for just returning 'year', One for 'Employee Name/Code' and so on inside the single DTO class.
Is there any way to combine multiple Audio Files (.wav etc) into one file?
I have found an example here :
[URL]
Quote:
[code]....
Is it possible to have ON and WHERE , both keyword using Joins in a single query
View 6 RepliesI am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....
At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.
Month-download-GameID-UserID
1 1
1 1
1 1
1 1
Here I'm using three tables given below. As u can see in the below three tables, 3 columns(P_Id,PdtName,PdtImgUrl) are same. Now can any body tell me how can I retreive values of 3 columns(P_Id,PdtName,PdtImgUrl) without repeatition.
Coming_Products(C_ID,P_Id,PdtName,PdtImgUrl,PdtRetPrice,Startdate),
Live_Products(L_ID,P_Id,PdtName,PdtImgUrl,PdtRetPrice,PdtCurPrice,UName),
Ended_Products(E_ID,P_Id,PdtName,PdtImgUrl,WinPrice,SavingPrice,UName,Endeddate)
I have a requirement to create multiple hyperlinks dynamically in a single GridView Column. The number of hyperlinks are not not known in advance and will depend on the results brought up by a query. How do I create the same?
View 4 RepliesI am using below query to count a particular column data based on single condition.
[code].....
But I have to calculate for 3 more conditions. Is it possible to count based on 3 conditions(i.e. 2001 - 3000,3001 - 4000, 4001 - 5000,>5000) and I want result set for all the conditions?
I have a sql table like this-
Sno part_no desc supplier currency price
1 10245890 abc abc electricals INR 0.320000
2 10245890 abc abc electricals INR 0.560000
3 10245890 abc def electricals USD 0.780000
4 10345780 def xyz electricals YEN 0.345678
5 10345780 def pqr electricals USD 0.000678
Now whenever user input the part_no output should be displayed like this- foe eg.. if user input 10245890, the ouput should be like this-
Sno part_no supplier1 currency1 price1 supplier2 currency2 price2 supplier3 currency3 price3
Means vertical records for particular part_no should be horizontally displayed in a single row. How can i write a sql query to achieve this?
For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.
I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.
I have tried to accomplish this using many variations of the following code:
[Code]....
In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.
How can I make this work? I have yet to see an example or article out there to do what I am trying to do.
Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.
View 4 RepliesI have a view that has to render information from 3-4 tables. I therefore chose to create a viewModel for this. I am using EF as DAL.The information to be displayed is SiteId, SiteName, SiteDetails from one table.Associated to Site, other table Event_type has information about Events in the system with fileds like EventId, EventName, Event ScopeId.EventScope is another table with ScopeID and ScopeDesc Also, there is Site_Event_Implemnetation table that stores all the events associated to a site. It has SiteId, EventId, EventUnitIdEventUnit is another table that stores all the unit types.Now my Details ViewModel has to display the info SiteName, SiteDetails. And associated to that a grid of events with info on EventName, Scope Desc, Unit Desc1. How do I formulate my query to retrieve this info in my repository layer using Linq to EF?
View 13 RepliesI want to create password in single database for example when i attach My database abc.mdf or open that database then it ask me password. as like access database password..
View 3 RepliesProgrammatically i am planning to move multiple files, Is it possible to move multiple files to a folder "d:MyTempFileFolder"
and create a compressed zip file of all files which are in this folder: "d:MyTempFileFolder" and then will try to download it.
using asp.net / sql server on windows 2003 server
how to run multiple queries on a single button click. Actually I want whatever a user write in text box and click the button the text would get inserted in table category and also a table name project should get updated. I am using Sql server 2005 and c#
View 2 Replies