I have a sql server table with 2 cols. text, image. and i want to display these in a gridview or any table format. but i want pics to appear like this:[URL]..pics are side by side. how do i achieve this in vb.net.there will be 100s of pics and i need paging functionality too.
View 2 RepliesI am developing windows application. Now I have got the data in the data set . Now I need that to be displayed in the table format, not in the grid.but in the table format as we get in web applications.Is it possible to achieve it? If so how could it be archived?
View 1 Repliesformat Gridview's unbound column in 12hr format? i tried the following code, it didnt work.
[Code]...
My database : table1
ID FIRSTNAME AGE
1 Sumit 22
2 Sanjeev 23
i have gridview 1 and textbox1 and button1 i want when pages load the gridview displays the all records from table1 and also ...i i wanna search record for firstname by typing sumit in textbox1 and click on button1 then in gridview the record of sumit will be shown ..by default gridview display alll records from table1 How to do this My Selct Query is below : but it doesnot display all record ...but it can display record if you search for a particular record .
[Code]...
i think this might be an unusual one and i've been tearing my hair out trying to figure it out. I'm hoping someone may have done this before
[Code]...
I have a datagrid and one of the columns show the size of a file.
Ex:
87 bytes
978 kb
500 Mb
766 Gb
If i get the number of bytes, calculate the correct value (in kb, Mb or Gb) to show as you can see above and add the value on the cell, it works but when i try to sort the column it does not work. It get's the wrong order.How can i format a column on a grid view so the sorting works correctly?
Having a problem with Gridview losing it's column width, font, headings, etc when attempting to change font/color when null fields exist.
Here's my code that works correctly
HTML
'>>==== Highlight a Row after grid is sorted ======
'can be used to show 'over budget' items highlited in Red Italics
For i = 0 To DgvGrid.Rows.Count - 1
If Not IsDBNull(DgvGrid.Rows(i).Cells("BudYtd").Value) Then 'Only test Non-Null Values
[code].....
I have a gridview with autogenerated columns that I set programmatically I want to format the column width. This is my code for my gridview in code behind...
If Not Page.IsPostBack Then
Dim budgetTable As New DataTable("Budgets")
budgetTable.Columns.Add("Approval Date", GetType(Date))
[code]....
I have a gridview export i am working with which works great except formatting on one field One column which is a character field and lets say it has a value like "10637020409092000"Well end up formatting to 1.0637E+16Its an alphanumberic field and if field has an alpha in it then all is great4679612190809391AHowever all integers and it gets goofyHere is the export function i use.Curious how i can format this field properly
Protected Sub ExportGridView(ByVal grdView As GridView, ByVal filename As String, ByVal excludedColumnList As ArrayList)
' Clear response content & headers
[code].....
I am trying to format the width of my gridview columns dynamically for easy of use in editing and updating. Is it possible to have multiple column widths defined? Here is the code I am using to create the gridview...
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
[code].....
i am trying to insert date in dd/mm/yy format in sql table from a textbox but everytime the default date 01/01/00 goes in table.
View 19 RepliesI have created a Stored Procedure in SQL which produces a pivot table. I've successfully created a GridView in ASP.NET to display this data.
However, some of my column headings are dynamically generated from the data (AutoGenerateColumns=True), and those column headings are just dates, so they will look different almost every time the table is generated.
This all works fine, except that the date format of the column headings is wrong. I know I could change the way SQL produces the dates in its output, but I don't want to do it that way. I want to control it from the web page.
I didn't think this would be difficult - I thought I could just do something along the lines of finding the cells in the header row and changing the datastringformat. The problem is that whether I put my code in the GridView's DataBound or RowDataBound event, the cells in the header row seem to be empty, so I can't reformat them. It's as if the headers get populate some time AFTER the DataBound event, but I don't know when or how to trap it.
I am putting together a kind of "build your own report" page that will have up to 20 options for people to select.Each option, selected by checkbox or dropdown (probably) will add on to the SQL data source to pull only the information needed and display it in a gridview.For instance, the initial query is:
Select
C.Name,
From Clients as C
[code].....
How can I do this, preferably referring to the column using the column name of "My Position" and not a numeric...If this can NOT be done....The other option is to query everything and format it - and then hide columns in the gridview based on items that are not checked. Would this be easier? (Doesn't sound as efficient to me).
I currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
i have to create a mortgage calculator (I know we have killed this mortgage calculator). Has to display an amortization table to display the list after doing the calculation. Here is the actual assignment:
Write the program in VB.Net (not Web based) and have it accept user input of the amount, term and interest rate. Display the mortgage payment amount. Then, list the loan balance and interest paid for each payment over the term of the loan. The list will be longer than the screen, so use loops to display a partial list, hesitate, and then display more of the list. Insert comments to document the program.
I have created 4 buttons. Calculate, Clear, List, and Exit. The buttons all work, but the list does not. Not sure what i am doing wrong.
[Code]...
The gridview on my page is set up with templat fields in each column so that I can enter information and save it to my database. There is no data that ties directly into the gridview just the ability to add multiple rows at a time to save the data. I had it displayed with empty textboxes and it was working fine and all of a it stopped and now won't show up. Any clues as to what is happening. Code follows...
[Code]...
<asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataSourceID="opendiarysource" Font-Size="Small" style="font-size: 8pt; border-top-style: solid; border-right-style: solid; border-left-style: solid; border-bottom-style: solid; color: black;" AllowSorting="True" >
<Columns>
[Code]...
i use this command to display data from my ms access database table, but, it is not working
[CODE...]
i am using asp.net and vb.net. i can upload files in to my folder called uploads located in c drive. C:uploads. the files are word files(.doc, and .docx), now i want to show these files in gridview, and the these files should be downloadable from the girdview. so how do code it?
View 3 RepliesI am using visual studio 2008. I have a winforms app that takes data from an xml doc. I store the data in a ms sql database that I have created via a stored procedure. When Irun the app the data from the xml doc is captured and put in the database, but I can only see old data, the data that is captured during the current session can not be seen unless I close the app down and restart it. I have tried the following, and every variation I can think of to allow me to see the new data but to no avail.[code]
View 4 RepliesI have created 2 gridviews.In gridview1 the database table is displayed.The gridview1 is used to show the books list.It is used to search books.Once the user chooses the row then that selected row should get displayed in the other gridview2 with the additional columns->details like date of issue,date of return and other details.I thought to do the coding for this in button itself by adding button on gridview1.I tried to do this but not able to do it.
View 7 RepliesYesterday I attempted to add some code to turn one of the cells a different colour diring databinding method. When I added that code and debugged, my gridview stopped showing data.
So I took the entire method OUT...
Now my gridview does not display even when I put a STOP at the page load method, and it shows the gridview AND SQLDATASOURCE as having rows.
in Gridview shows customer details, now i need to add one column for timer,ie, Each row having start button, while press the start button that current row timer starts now and hide the start button and show stop button.so finally press the stop button, we calculate the logged in duration....Table FieldsCustomerName Mobileno Systemname(combobox) starttime Endtime start/stopwe click start button means set current time to start time and timer starts end time time column and display.
View 2 RepliesWell the problem is probably me not doing something right but we will se.I have a form w/ just a datagridview on it. I have set the data gridview to connect to a table. I adjust the querry to only return 1 row.So it looks like select * from table where ident=@realident..so the problem is i want to use a variable from the form to be the @realident and i want it to auto load when the form loads not have to type it into the tool bar like you have to do by default.Also once the data is returned I would like to be able to edit a field or two in that data and have it save back to the db.
View 3 RepliesMy sql query is returning records from the database that contains a filename. I will be appending the filepath (from the web.config file) to allow the user to download the complete file. However, another colum in the grid, has to be the file size. How can I obtain the filesize, given that the name is being returned from the database, and the filepath is from the web.config file?
View 4 Replies<asp:GridView ID="gvNames" runat="server"
OnRowDeleting="gvNames_SelectedIndexChanged"
AllowSorting="true"
[Code].....
How to display whole records from database in Gridview and also do filteration using textbox ?
View 1 RepliesMarkup:
<asp:GridView ID="GridView1" runat="Server">
<Columns>
<asp:BoundField DataField="status_column" HeaderText="Status" />
[Code].....
The values stored in my database are integers, 1 - 9. Each value has an associated string value that I want displayed in my GridView. Ex: 1 = "Active"; 2 = "On Hold"; etc. How would I filter the incoming data so I can display the associated String value instead of the Integers from my table?
i am trying to make a search form with 1 label(surname) and textbox. i have 1 gridview on the form aswell. can you plz provide me any code so that when i type in textbox i should c the result in the gridview. wat i have done right now is. i have added data source and i than dragged the dataset.but when i load the form i already can see the data loaded on grid view .it than filters depending on the textbox. i want this gridview to be empty when it gets loaded.
View 4 RepliesI'm trying to build a page in which the users should be able to type a name into a search box, click search and the name will be displayed. My problem is that I also want them to be able to edit the name and update it, and this is not working for some reason. I'm using GridView and because of the way my search function works, I can't link the GridView directly to data source. What function do I need to add to make the uploading work, or what do I need to change in my search function so that I'll be able to link to data source a(nd have the upload function be automatic) ?
My code for my search function is :
Sub btnSearch_onclick(ByVal sender As Object, ByVal e As EventArgs)
If (txtSearch.Text = "" Or txtSearch.Text = "Enter Search Here") Then
Response.Write("enter a search value!")
Else
[Code].....