Suppose I have a folder inside the web application:-
applicationdatabase
In this folder there are 3 files
1.xls
2.mdf
3.jpg
How to get the 3 file names into a Gridview ?
i seem to have a problem with my gridview, i have a gridview with a list of names, this gridview is assign to a datasource and the datasource already has a select statement to display a list of names to my gridview, and i have a search dialog which i use to filter data to be displayed on my gridview, my problem iS after filtering , when a user select a certain row the gridview refreshes and display the initial data(it binds again the use the default setted select query). On my search i use
SqlDatasourceName.SelectedComman = filterQuery;
SqlDatasourceName.DataBind();
GridviewName.DataBind();
to filter the grid according to my search criteria, which is the one i have assigned its select to the string varieble filterQuery.
That works fine, and dispaly only d data i setted my search to retrieve, bt my problem is when a user select a row on d gridview , d gridview is repopulated with d initial data(Use initially datasource select statment). How to make d grid to stick to d select statement that i setted on my search and not letting it to go back to the initial setted select.
I have a web in ASP.NET+VB code and there is a folder named POLICY and there are pdf files in it. i want to display the list of files in a aspx file with hyperlink so that the files listed can be opened...
View 1 RepliesI 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.
when i m trying to open file which are in sub directory it's giving me error while opening or redirecting to it
[IMG]http://i56.tinypic.com/2h3dma8.jpg[/IMG]
My Source
[Code]....
My Html Source
[Code]....
populating the dropdownlist with column name. I have a gridview that has 7 columns . I want to have a textbox search and dropdownfield where user can select column name and type a word in search box and click search so that text for that column name is being search and displayed in grid. how I can fetch just column names from DB and search ?
View 1 RepliesI have "Testdtabse" it's consists of the Table like aaa,bbb,ccc,ddd,eee etc.. I want to bind that table names in to My droipdown list box..
View 5 RepliesI have a gridview which is pulling data from sql server2005. Now i have five pdf or jpg files in a folder in my website directory. There urls are stored in sql table like this
myfileuploads/Picture5.jpg
Now i have an itemtemplate in templatefield in gridview
I want that the above url should be displayed in itemtemplate and whenevr user click on this link, related file should be open
HTML/JS
Page with 1 button and 1 jQueryMobile ListView
On button click, send AJAX request to webservice to get list of names as JSON
Bind the list of names to jQueryMobile ListView.
There are about 50 controls including labels, text boxes, radio buttons, buttons...
How to list all names of controls in a page?
I have a gridview that is dynamically created based off a csv file I'm importing.
Since I don't know what the column names are ahead of time, I can't pre format the gridview and use the "findcontrol" method to get the text value of the labels that are populated b/c I don't know the column names.
I know I can get the row index like this by iterating through the gridview...
[Code]....
but I'm not sure how to get the text value of the first column label? Not sure of the syntax?
I want to write the default column names in gridview when the data is not coming from the dataset or you can say that datset is blank.
I tried to use this [Code]....
But this does not help me and i am not able to see the column with name as 'ID'
I currently have a gridview that has autogeneratecolumns = true. Right now, I am trying to find all the column names of a given table. Since auto columns arent part of the columns collection, Grid.HeaderRow.Cells[i].Text does not work. I have also tried
[code]....
i want to display name of related table in my gridView insetad of it's id. one solution is using sqlDataSource or objectDataSource, but i don't want using this appproach. i want to do this without setting any dataSourceID or join tables, in other word, i want to do this like windows form datagridViewComboBoxColumn.
View 3 RepliesI'm using a windwos authentication via intranet. I'm able to display the username in a label control on a page load event (which is very simple).
I'm not storing this data anywhere in the table (MS SQL). I have all my data in a table and I'm using a gridview to diplay them. I'm using a button control to update all the rows in the gridview. I wanted to update three columns in the gridview (1. Tickbox, 2.Datetime Stamp and 3.UserId).
I've created a query in the dataset, through which i can update the Tickbox and DateTime stamp using now() function. But I'm not sure how to update the UserID field with the UserName (which inturn updates all the three fields in the gridview when the button is pressed.
I am using Asp:TemplateField in gridView. I have only ONE TemplateField as follows
[Code]....
I want to find all the textboxes (when grid row is in edit mode) using some kind of loop. I don't want to find the TextBoxes by their names like e.row.findcontrol("..");
I did Response.Write(e.row.controls.count), it show "2". How can I find textboxes without using names
I'm trying to create a list of image buttons dynamically, but I'm having trouble displaying the images. I'm using the Directory.GetFullPath method, but I don't think its the right thing to do.I've viewed the page, and the image path is showing as
'd:Hosting6238630htmlPropertiesCedarsext%20front.jpg'. I know this isn'r right and that it needs to be something like www.annereevelettings.co.uk/property/images..., but the question is, how do I do it?The page can be seen at the following address
www.annereevelettings.co.uk/property.aspx.
Here is the code that I am using:
[Code]....
There are about 50 controls including labels, text boxes, radio buttons, buttons. How to list all names of controls in a page?
View 4 RepliesI have a page that shows a list of the files in an upload directory. ie: My customer uploads a file through my web page and the file ends up in the proper directory. When I click on a file name, the url path is missing the directory name. It's as if my customer uploaded directly to my root. Interestingly, when I upload a file through the same web page, the path remains intact and I am able to click on the link and download the file. How can I get the proper path in my url name. Here is my code .
[Code]....
I am trying to populate table column names into a dropdown list . how can I query using Linq to SQL to just get the list of few Column names ? in a method in DAL which I can use to load in my UI page !!
View 2 RepliesI have a list and I want to return all of the field names.
Something like
[Code]....
I have a page url say [URL]. So in that page I have links like "About us" "Contact us" etc. So when it comes to development, I have folders called "ContactUS" "AboutUS" and in them I have pages called "ContactUs.aspx" and "AboutUs.aspx". So by default, when you click on the "About us" link from the website, you would be directed to a url, [URL] But in my case, for any web pages, I dont want to show the last part of the page name. So the url should look like [URL] So how do I do this?
View 2 RepliesHow can I specify the DLL names in the bin directory when the application is deployed - even with "Use fixed naming and single page assemblies" option checked, it still appends "random" characters to the DLL name.
View 1 RepliesI have a Webform with a large number of user controls on it, they were auto generated as part of a formview.
I would like a way (Add in etc) to print a list of all of the names of the controls for me to use for the code, rather than having to go through and write them all down.
does anyone know of an add in or an easy way to do this in VS2010..?
I have a form that users submit which automatically picks up the user_id of that user with:
string usrName = Request.ServerVariables["AUTH_USER"];
This is fine for the userid textbox but I would like to pull the persons name as well which would be stored in Active Directory. I'm still really new to asp and c# so I'm not sure how to connect to active directory and then pull the information I need.