I am looking to create a stored procedure OR a SQL Transaction that will allow me to submit the data input into one single text box into two different tables.The data to be input is the same for both tables and the column names are the same as well.
View 4 Repliesim tryin to do something without success. I have some SQL table with few columns (fileId(int), fileName, copies, color and finish), the page is build in a way, that the user upload few files (the files uploads to some folder, and the fileId and fileName are write to the above SQL table - so the other columns (copies, color, finish) are stay blank - which is OK!!!) after he finished uploading the files he can see the files names in GridView and in that grid view i put some textbox for copies, and 2 DDL for color and comments. I need to update the rows with the new data after the user click some button (the all rows) this is the code:
aspx
[Code]....
the aspx.cs
[Code]....
I was able to find examples throughout the internet that more or less accomplished what I needed to be done, but now I have run into some problems. I need to be emailed the form data when the users submits it and then the user needs to be redirected to a thank you page, in this case "thanks.asp". I have been unable to get the form to redirect users to the thanks page, and in my efforts I think I might have messed the email process up as well.
[Code]....
What is the best way to format a grid, (or any other control) in this format?
Header1 Header2
A B C D Header3 Header4 header5
row
row
row
row
row
Header3 Header4
row
eader5 Header6 header7 header8
row
row
row
footer data
is this format even possible?
How do you get a Multi line header for a Gridview in Asp.Net. I have tried setting wrap="true". I have tried
HeaderText= "Abnormal /n/r Mild PFT".
<asp:BoundField DataField="SEL_PARAM" HeaderText= "Abnormal Mild PFT" SortExpression="SEL_PARAM">
<HeaderStyle Width="20px" Wrap="true" Height="20px" />
</asp:BoundField>
I have found demos of multi-edit gridview which basically mark each row as edited then loop through them:
http://msdn.microsoft.com/en-us/library/aa992036(v=vs.80).aspx
I would like to avoid row by row loops for performance reasons possibly using the SQL Server 2008 "MERGE"
I program in VB.Net but I can use C#.
my gridview shows multiple repeated pages for one page and I dont know from where come the problemand im treating the event of the paging well
Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs)
GridView1.PageIndex = e.NewPageIndex
If lstCustomer.Visible = True Then
[code]...
I'm a complete novice in .NET. I am trying to implement a multi textbox / dropdowns / checkboxes search for a website using vb.net. How do I pass the values of my form fields to my griedview and display the search result on the same page?
I've written a stored procedure and specified it as data source for my gridview and defined parameter source as my CONTROLS (textboxes, checkboxes n dropdowns) on the form. What I want is when a user fills out one or multiple fields on the form, how do I display data in the gridview on the click of SEARCH button? Also is it necessary to write a codebehind for my search button or we can achieve the desired result in some other way?
How to create Rows and Column using Datatable Gridview Itemtemplate with multi header I need to create Datatable Gridview Itemtemplate fixed rows and column such as 7 rows and 7 columns
[Code]....
i have a form which has two textboxes and a submit button.on entering data and submitting data gets stored in the database.but if i again refresh the page the same data again gets stored.How should this be prevented?
View 3 RepliesHow to display empty GridView to insert new record if no data retreived for some record on the result from data table?Actually i am trying to give a user an option to add recrod from Gridview. On result of some query it is perfectly displaying data and a footer row with the insertion textbox but when there is no data in the gridview it is not displaying. It should display with footer having insert textbox.
View 5 RepliesHow can i refresh(Asych) the contents of my Datalist on the parent page from a data change in a page that is displayed in an iFrame on the parent page.
I have movie names with image in the data list that is on parent page.
there another page is openend in the parent pages in an iFrame control.
in that sub page i upload image and other data related to a new movie.
What i want is that when i submit that information in an iFrame page, the DataList should update(Asych) itself on the parent page showing new updated info.
the structure is like;
[code]...
I have a problem with exporting three gridviews (main and nested gridview and sub nested gridview) to Excel fromat using ClosedXML (XLWorkbook). I read tutorial on aspsnippets and it works fine for main gridview. i refered in link [URL] ....
But its only for two gridview but i need three nested gridviews export to excel ....
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
gvCustomers.DataSource = GetData("select top 10 * from Customers");
gvCustomers.DataBind();
[Code] .....
One of my apps is to document aircraft inspection at mil sites. The discrepancy report for any one tail number can be many pages long. The description of the discrepancy in a gridview cell can be several lines. Therefore when the gridview hits the bottom of the physical page, the print spooler frequently splits the gridview row leaving part on one page and the rest at the top of the following page. I have done my due-diligence in research before posting but maybe I'm using the wrong words. I found something on CodeProject but it is too complicated for me. Does anyone have a simple solution? I use C# and am not very sharp with Java script.
View 6 RepliesI am using an ADO Entity Model for my ms-sql database.
My database has a Resellers table which has ResellerID (primary key, int) and Name columns along with other data.
I also have an Orders table which contains OrderID (primary key, int), OrderDate, ResellerID (foreign key to Resellers.ReselerID).
If I just do a query like:
[Code]....
I am able to reference order.Reseller.Name just fine with no problems.
However I have an EntityDataSource on my page as follows:
[Code]....
Notice the Include="Reseller" attribute in the datasource... I also have a GridView tied to that datasource as follows: I cut some of it off for breavity:
[Code]....
Now what I have listed above will run with no errors, but what I want to do is replace the column that displays "ResellerID" with the equivilant to order.Reseller.Name. In other words I want my grid to display the reseller's name rather than the numeric ID.
I have tried to change the DataField to "Reseller.Name" but that will generate the following error:
A field or property with the name 'Reseller.Name' was not found on the selected data source.
Is there anyway to do this without me writing a custom select statement in my code behind?
I have created a gridView control and have successfully bound DataTable (dt) to it using
[Code]....
However, I want to add a dynamic hyperlink that will take the user somewhere based on the value of one of the columns in the selected row. I'm not sure how to do that.
I have a datatable with the following column names
ProviceID, ProvinceName, Year,
TPM, PM 10, PM 2.5, B(a)p
I'm trying to display data from this table in a gridview using template fields. Here's an example of a label in my item template
[Code]....
When i bind data to this grid view, i get an error saying column "PM 2" was not found. For some reason, the program is dropping the .5 from the column name. I am exploring the possibility of replacing the number with alphabets only but this may not be possible as the end user may not find it user friendly. Is there a way for me to get around this problem? I get a similar problem with B(a)p, it drops everything after the B. Any ideas on how to get the gridview to bind column names with special chars in it?
I want to bind gridview with datatable in this dt ihave 4 columns , dt
Id Name isdelete value
1 xyz true
2 uio false
3 bbb true
4 ccc false
this is gridview
[Code]....
but i want not bind those rows whose isdelete coumn value is false and i want to show 4 th column as textbox and user will enter some text or number and if he click save button outside of gridview one record shld save in database
I have gridView with checkbox on each row, when user click "Submit" then I want a loop go through the gridview, then save those are checked.
ClientID | Client | Emails | chkBox |
[Code]....
On the code behind, how can I identify the data on each row to save to database?
[Code]....
I've got a gridview that is databound with LINQ in the code behind. One column shows the id from the table. I would like to show a more human friendly product name that is associated with that id number but is from another table. Thought I had it figured out by entering a Template field in the gridview tags (in the .aspx page) and an item template within that with
<ItemTemplate>
<%Eval(Products.productName")%></ItemTemplate>
but when I try to build it says this can only be done in the context of a databound control.
Can I add this column within the gridview tags or does it have to be done from the code behind?
i want to get multiple row data from a data base table and display 1 record per specific group as shown below in a gridview. for example.
two columns with this data.
1 Good
1 Bad
1 Neutral
1 N/A
2 Excellent
2 Poor
3 Yes
3 No
3 Maybe
The data needs to display in the gridview as such.
1 Good Bad Neutral N/A
2 Excellent Poor
3 Yes No Maybe
my gridview binds to a datatable and i added a template field to the columns the template field contains a link button. i bind the command argument of this link button to a field from my data table. on the row command event i allow the user to activate his product according to a condition. what i want is how to add a javascript alert if the condition doesn't match. in other words i can't call the hyperlink in the templatefield in order to add a javascript to its OnClientClick attribute.
View 8 RepliesI want to show the textbox which is in Gridview, eventhough the Datasource[Table] of the Gridview is empty.The user has to enter some value and save it in the table. My problem, when there is no value in the table, textbox is not shown. I am using Linq, So the Gridview has to bind using Linq list or table The objective of the task:
1. Show the blank textbox when there is no data in the table.
2.A Addnew Buton has to show, If the user clicks the Addnew button, One more textbox has to shown and user can enter the second input.
I have a gridview which I have databinded via the quick config facility, but I need to databind one column to a completely different sql table data field - how do I do this?
If I go into Gridview tasks and select the column and edit the data binding parameter but what is the format for a table outside the source definition for the the rest of the gridview?
I'm a bit of an ASP.NET newbie and I am creating a data table in memory and binding this to a gridview control. The code is as follows:
Dim DstBasket As New DataSet, TblBasket As New DataTable
With TblBasket
.Columns.Add("BskPrdCd", System.Type.GetType("System.String"))
.Columns.Add("BskPrdDesc", System.Type.GetType("System.String"))
.Columns.Add("BskQty", System.Type.GetType("System.Int16"))
.LoadDataRow(Split("12345,Test product 1,1", ","), True)
.LoadDataRow(Split("122,Test product 2,2", ","), True)
.LoadDataRow(Split("123A,Test product 3,5", ","), True)
.LoadDataRow(Split("44,Test product 4,1", ","), True)
End With
DstBasket.Tables.Add(TblBasket)
With LfnGridView("GdvBasket")
.DataSource = DstBasket
.DataBind()
End With
The data displays in the gridview control fine with both edit & delete options but when I attempt to delete, it has no effect. How do I force removal of the relevant row from both gridview and table? Most of the documentation I have unearthed shows how to achieve this when connected to a SQL table which is clearly not the case here.