I have DropDownList displays all server present in my network I want to populate the databse names when i changed it into another dropdown I want a LINQ query to get this.
View 3 RepliesHere is what I am basically trying to accomplish I want to upload images to the server separated into categories and save the file path into the database. I have found plenty of documentation on saving to a file and the file path to a database. But, I haven't found anything that will allow me to seperate the images into categoies.
I have made three tables in the database
[code]....
What I am trying to do is create a gallery for our clients to browse and download different vesions of posters and ad cards.
how to get column names from linq datasource?
[Code]....
I have to be able to dynamically change the sproc name that is used in a Linq to SQL query. I see in the dbml designer this:
[Function(Name="dbo.InsertUnknownMessage")]
I watched many videos about using LINQ to SQL, I am happy I learned something,but is it the good way of using is: dragging and dropping and that's done???what are the best practices to use LINQ to access Database ( my database is not only SQL server..MYSQL..)
View 1 Replieshow to insert record in sql server database by using linq?
still i m using MVC 3.0 send me full detail example for insert record using Linq
My team working asp.net File manage project. In our project we need to export database contents to csv formats
The Database table contains 6 fields. We are using LINQ.
I am a little new to this concept so bear with me.1) I need to query atleast 35 tables using linq to sql(SQL server database) . I am not able to add all the database entities in Linq to sql classes?
2)(View Model issue) When I use List<Reportcollection> and also List<Receipt> to convert the result then its giving an error that "Cannot convert list<anonymous> to list<string>"
I tried this code by inputting the ftp address as ftp//: and the correct username and password and I get the following error
"Unable to connect to the remote server" on line :
FtpWebResponse Response = (FtpWebResponse)Request.GetResponse();I tired this on my ftp server provided by a hosting service and an anonymous ftp located at 193.166.120.5 ?
Note: I was able to connect to both of these ftp through filezilla, via a webbrowser, and through windows command line.
I have been working with this database for some time. Here is the situation...
I inherited a MS SQL database that has hundreds of tables with similar data. For instance:
FordTampa_customer is a table,
ChevyAtlanta_customer is a table, etc....
All of the columns are the same...just different tables with their own ID field. All I have done...Inside of another database id is created a table called 'Customer' and added an 'Dealer ID' column along with the rest of the other columns in the other tables...
So the combination of the 'Dealer ID' and the 'ID' field are unique.....I know...its not the best way to do things...but I cannot change the old data structure because I cannot have access to it. I am give back-ups on a weekly basis, so this is all I have to work with.
All right, on to the real point of my post...
Currently, I have an application that I use to select all of the data from the 'Ford_customers','Chevy_customers',etc... and inserts them into my new main 'Customer' table. I do this by selecting the table names, bind it to an arraylist, loop through the list and execute an insert statement.
I do this in VB.NET, but I would prefer to do it in a Stored procedure of some kind....I just am not sure how to accomplish it. I use this syntax to get my list of tables:
[Code]....
I am not sure how to take those names from the table and do another select based on that list of names.
I am learning asp.net web development. I have create a table with the column "username". But i don't know how to prevent the Duplicate "username".
View 5 RepliesGiven a string in my database like "Computer Gadget", I am trying to achieve a url format like "http://xyz.com/products/details/computer-gadget" when a user clicks a link to the item "computer gadget" from a list view.In my list view for the products, I have Action links that read like this
[Code]....
When I hover over this link on the rendered page I get a link that looks like "http://xyz.com/products/details/computer+gadget"and the correct product detail is returned after I have url.decoded the string in my Details method. However, the returned page displays a url that looks like "http://xyz.com/products/details/computer%2bgadget"How can I get the returned url to show "computer-gadget" instead?Also when a name has "&" or "/" the server throws a Http 400 error message. I know these are unsafe values, but is there a way to work around this safely to allow the strings keep these characters?
We are buling a hosted ecommerce shopping cart solution and I would like to use asp.net's built-in membership provider. We dont really want to have a seperate database for each domain, we want to share the same database across mupltiple domains for different customers. Each domain is a seperate store.
My problem is that since it's a shared hosted solution people coming from different domains might use the same user name and it would show as if already existed. Is there an addional field I can use to store the domain name so basicly would be unique by username and domain name. We don't want to share information between stores.
Like this: select * from foo where @nameofdbcolumnprovidedbyparam = 1? Whenever I attempt this with sqldatasource or in ado I get errors such as: Syntax error converting the nvarchar value 'foo' to a column of data type int.
View 3 RepliesRather than having a details button next to the database entry I would like to make a link out of the name field.basically i want the item.Name field to be the name of the link in theHtml.ActionLink(" **here*** ", "Details", new blablalba)What is the syntax to do this in asp.net
View 1 RepliesI have a mssql table of names. This table contains names from A thru Z. However, I want to be able to display names by their beginning alphabet...Like first Display names A thru CThen Display Names D thru F
and ..so on....and so forth....thru ZI using asp.net and have a grid view with paging enabled.....
I've watched the Slideshow videos and created a number of examples that run fine. The code I've attached at the bottom is the smallest one, but instead of hard coding the image locations, I would like to select the slides from either of the following statements, which return the top 5 images selected randomly from our floorplans database.
<asp:AccessDataSource id="AccessDataSource1" runat="server" DataFile="../fpdb/J3_2005.mdb" SelectCommand="SELECT TOP 5 [Elev_Pimage] FROM [PLANS_Active] ORDER BY RND(INT(NOW*[SF_Total])-NOW*[SF_Total])" />
or,
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:J3_2005Slideshow %>" ProviderName="<%$ ConnectionStrings:J3_2005Slideshow.ProviderName %>" SelectCommand="SELECT TOP 5 [Elev_Pimage] FROM [PLANS_Active] ORDER
BY RND(INT(NOW*[SF_Total])-NOW*[SF_Total])" />
<title>SlideShow</title>
[Code]....
Refer to datatable columns with database column names?
I have a folder with 200+ pictures. I want to get the names of each of the pictures to the database. would it be easier to import and export the images into the database (I want my webpage to be able to show the images once they are in the database)?
View 12 RepliesI have many images on remote server say [URL] & i want to access file names of all files that resides in the folder 222 on [URL]
i have tried following code but getting error "virtual path is not valid" :
imageserver = http://images.foo.com/222;
DirectoryInfo di = new DirectoryInfo(imageserver); // line giving exception
FileInfo[] rgFiles = di.GetFiles();
string simagename = "";
if (rgFiles.Count() > 0)
{
foreach (FileInfo fi in rgFiles)
{
//collect each filename from here
}
}
I'm using SQLSERVER 2005, In "Connect to Server" window I want to remove some all server names (like cookies in Textbox) which I used. When I click on this dropdown it listing all server names. I want to remove these.
View 1 RepliesI have asp.net application, using LINQ to connecto to SQL Server 2008 R2 databse. My connection string: Data Source=[SqlServerIp];Initial Catalog=[databaseName]User Id=newLogin;Password=newPassword; When I deploy application on my local IIS (which is not the same machine as database server)
it works fine, but when I deploy application on other IIS (the same machine as sqlServer) it throws an exception: System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. how to fix it? Maybe it is due to some bad configuration of IIS?
I have the following SQL:
SELECT SRFILE_1.SRCONMAE, COUNT(LBWF_1.Incidentx) AS SLAFailed,
(SELECT COUNT(Incidentx) AS Expr3
FROM LBWF AS LBWF_2) AS TotalCalls
FROM SRFILE AS SRFILE_1 INNER JOIN
LBWFAS LBWF_1 ON LBWF_1.Incidentx = SRFILE_1.SRONUMBER
WHERE (LBWF_1.KPIFailx = '1') OR
(LBWF_1.Chargex > '0.00') OR
(LBWF_1.LChargex > '0.00')
GROUP BY SRFILE_1.SRCONMAE
What I'm trying to do is divide TotalCalls by SlaFailed and * by 100 into a new variable such as Percentage. However, everytime I try to select SLAFailed or TotalCalls I receive a 'Column Names do not exist' message.
Is there any way I can reference said values?
I am working on a query to pull the revenue for the last 7 days, as individual days, to be used in a bar graph. My query does what I want it to:
[Code]....
My question is: How do I change the Date1, Date2, Date3, etc to display the actual date it is pulling from? So instead of Date1, it will say "Jan. 3 2011" and so on...
I want to implement an image gallery in asp.net/C#. I am using sql server 2008, visual studio 2010 and .NET 4.0.
I have made a webpage and now want to display 6 images as thumbnails (and their names just below the thumbnails) at the center of the page. The format of the display is something like this:
[Code]....
Basic operation is like this:
I pull images from a database and then display them as above as thumbnails. The 1 2 3 Next> are links depending on whether there are more than 6 images pulled from the DB. So basically the numbering 1 2 3 4 Next> is dynamic depending on how many images exist. Can anyone give me a basic overview of how this an be achieved? Should I be using a asp:Repeater or a asp:DataList for this kind of a display?