Forms Data Controls :: Use A Gridview For Insert Of Multiple Row Input From User?
May 17, 2010i want to use a grid view for data insert user can insert more than one row.
View 4 Repliesi want to use a grid view for data insert user can insert more than one row.
View 4 RepliesI have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesI have a gridview object to which I added
<asp:TemplateField >
<ItemTemplate>
<asp:CheckBox ID="chkCopy"
OnCheckedChanged="chkStatus_OnCheckedChanged"
runat="server" />
</ItemTemplate>
</asp:TemplateField>
The page count is set to 10, when the user checks the checkbox(es), I will need to insert those records in a table. How will I know which row was selected? I found an example (untried) that is designed to loop through and insert the necessary records; but it does not address inserting records based on selecting rows via a checkbox. How do I put everything together.
// open connection
mySqlConnection.Open();
//enumerate the items in the list
foreach (SPListItem curItem in curItems)
{
string sql = "INSERT INTO ImportNotifications";
sql += "
(SharepointID,Title,WorkOrderNumber,Status,Department,ClientName,WorkOrderDueDate,CreatedDate,CreatedBy,ModifiedDate,ModifiedBy,Late,LateRe
view,TrueLate,Body)";
sql += " VALUES
(@ID,@Title,@WorkOrderNum,@Status,@Department,@ClientName,@WorkOrderDue,@Created,@Author,@Modified,@Editor,@Late,@LateReview,@TrueLate,@Bod
y)";
mySqlCommand.CommandText = sql;
mySqlCommand.Parameters.Clear();
mySqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Float)).Value = curItem["ID"];
mySqlCommand.Parameters.Add(new SqlParameter("@Title", SqlDbType.NVarChar, 200)).Value =
curItem["Title"].ToString();
mySqlCommand.Parameters.Add(new SqlParameter("@WorkOrderNum", SqlDbType.NVarChar, 50)).Value =
curItem["Work_x0020_Order_x0020_Number"].ToString();
mySqlCommand.Parameters.Add(new SqlParameter("@Status", SqlDbType.NVarChar, 50)).Value =
curItem["Status"].ToString();
mySqlCommand.Parameters.Add(new SqlParameter("@Department", SqlDbType.NVarChar, 100)).Value =
curItem["Department"].ToString();
mySqlCommand.Parameters.Add(new SqlParameter("@ClientName", SqlDbType.NVarChar, 255)).Value =
curItem["Client_x0020_Name"].ToString();
mySqlCommand.Parameters.Add(new SqlParameter("@WorkOrderDue", SqlDbType.DateTime)).Value =
curItem["Work_x0020_Order_x0020_Due_x0020"];
mySqlCommand.Parameters.Add(new SqlParameter("@Created", SqlDbType.DateTime)).Value = curItem["Created"];
mySqlCommand.Parameters.Add(new SqlParameter("@Author", SqlDbType.NVarChar, 50)).Value =
curItem["Author"].ToString();
mySqlCommand.Parameters.Add(new SqlParameter("@Modified", SqlDbType.DateTime)).Value = curItem["Modified"];
mySqlCommand.Parameters.Add(new SqlParameter("@Editor", SqlDbType.NVarChar, 50)).Value = curItem["Editor"];
mySqlCommand.Parameters.Add(new SqlParameter("@Late", SqlDbType.NVarChar, 50)).Value = curItem["Late"];
mySqlCommand.Parameters.Add(new SqlParameter("@LateReview", SqlDbType.NVarChar, 50)).Value =
curItem["Late_x0020_Review"];
mySqlCommand.Parameters.Add(new SqlParameter("@TrueLate", SqlDbType.NVarChar, 50)).Value = curItem["TrueLate"];
mySqlCommand.Parameters.Add(new SqlParameter("@Body", SqlDbType.NVarChar, -1)).Value =
curItem["Body"].ToString();
// execute the command
mySqlCommand.ExecuteNonQuery();
}
// close the connection
mySqlConnection.Close();
i want to insert regular, strings in sqldatasource.
in the "sss" i put joe and in the saw i put 'no' and it doesnt work!
<asp:SqlDataSource
ID="sql3"
runat="server"
InsertCommand="insert
into inbox(message,title,sss,to,saw) values(@message,@title,'joe',@to,'no')"
SelectCommand="select
* from inbox"
ProviderName="System.Data.OleDb"
ConnectionString='<%$connectionstrings:
sql %>'>
<InsertParameters>
<asp:Parameter
Type="String"
Name="message"
/>
<asp:Parameter
Type="String"
Name="title"
/>
<asp:Parameter
Type="String"
Name="sss"
/>
<asp:Parameter
Type="String"
name="to"
/>
<asp:Parameter
Type="String"
Name="saw"
/>
I'm designing a web page that allows a user to enter previous employer information. I'll need the ability to add multiple user input sections to capture information for each previous employer. Is there a user input control I should use to do this? Is it possible to add additional controls or user input sections when a user clicks on a button?
View 3 RepliesI have a save button outside the gridview and I want to save all the values/records of gridview at once or row by row in database(sql server) .
View 1 RepliesI want to send mail tot multiple user using checkbox within gridbiew , but problem is it is sending mail to only first column email ID , and suppose i have four email id in databse then it will send 4 times mail to first email id,
OleDbCommand cmd = new OleDbCommand("select * from sendmail",con);
OleDbDataReader red = cmd.ExecuteReader();
if (red.Read())
{
StringBuilder str = new StringBuilder();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
bool isChecked = ((CheckBox)row.FindControl("chkSelect")).Checked;
if (isChecked)
{
str.Append(GridView1.Rows[i].Cells[3].Text);
SmtpClient sc = new SmtpClient();
MailMessage mm = new MailMessage("dnk247@gmail.com", red["nemail"].ToString());
mm.Subject = "hello";
mm.Body = "just say hi";
sc.EnableSsl = true;
sc.Send(mm);
}
}
}
I want to put an input table on a web page using ASP.NET. The input table has 3 columns: date, quantity, and price. The number of rows is variable, depending on user input. The code behind will read the data and perform the necessary calculations. The data will not go into a database. It would be nice to have some client-side or server-side validation for the data, such as required fields and range checking.
Which control(s) in Visual Studio 2008 will perform what I want to do?
I have a quick Linq to SQL question. I am trying to write a Linq query that has multiple where clauses depening on user input. What I would intuitively code is:
Dim arrTerms As Array = txtUserInput.Text.Split(" ")
Dim q = From newsitem In db.MyNewsTable _
Where newsitem.Contains(arrTerms) _
Select newsitem
Listview1.DataSource = q
Listview1.Databind()
Unfortunately, though, the "Contains" operattor does not accept an arraylist, or array, or anything but String.
I am developing a page where i have a grid in content page (inherited from master page) which i am populating using DATASET in code behind like this here is the aspx.
[Code]....
As you can see i have some bound fields and one template field called "txtValue" which is the only input in gridview. Now what i want is when user input the value it should check the FACEVALUE and see if the entered value is not above the FACEVALUE and then need to Input value - FACEVALUE and result should be displayed in REMAINING field which is also a template field as label control.
I'm new for asp.net and web development at all.
I want to filter user input before putting to database.
Are there common technics for this?
I have two ListBoxes. I can move items from one list box to the other. I have an Insertcommand for inserting added values from the "ActivePrograms" list box to a db.
my problem is that it inserts only one item when sometimes the user added multiple items.
how do I insert all existing items from "ActivePrograms" list box?:
second issue: how do I make sure the insert command go through the list of items in the listbox and makes sure these rows does mot already exsited in the db? in other words insert only NEW values for that 'Id' value
[Code]....
I have a simple form that inserts a record into a SQL table.
The fields are:
SerialNum
TagNum
PONum
Location
Address
Description
This works great. However, I have now been asked to have the form insert x number of records at one time.
They want to be able to fill out the following fields:
PONum
Location
Address
Description
and then have texbox where they can add a number and have that number of the same record inserted.
Name
Product
section of job
Quantity
Max Quantity
A
ABC
offset print
100
1000
B
ABC
water base
200
1000
C
ABC
offset print
950
1000
How to insert multiple records like above at once, and how to manage quantity user input is not over max quantity. In example above: Max quantity of Offset printing is 1000 (bind from database, visible=false)
Woker A does Offset printing with quantity 100, C does Offset printing also but with quantity 950, if we sum quantity A and C do will be over 1000 Ã message box: warning
I have Gridview on my webapplication and it is getting filled with multiple rows . When clicked on Save I want to Insert all rows without calling multiple database hits.
Is there any way I can insert all rows by single db hit?
I have gridview with 3 columns and one textbox in each column. My requirement is when i paste 3 cells of copied data from excel to textbox in first column of gridview automatically 2nd cell data has to be pasted in textbox of 2nd column and 3rd cell data to textbox of 3rd column of gridview. How can it be done and can anyone provide the best code.
View 3 Replieshow can i generate rtf file based on input field(textbox input by user) c#
View 3 RepliesI have a datagrid that the user can edit and click a checbox then input their initials to update a task. The update works except it does not record the userid field. Below is the gridview code and the vb/sql
[Code]....
I have a listbox inside a formview in a details page(master/details). The values for the listbox will come from a lookup table and when the user select one or more values it should be inserted in a table. The process sould be like the following:
The user will select one or multiple values and click on a Select button. Then a label should show the selected values. Then the user will click on the Insert button in the formview to insert it in the database.
I have three column comes from database table(Table1) and one column is for entering data for the user let us consider it look like this
ItemNo ItemName Qty uservalue
001 A 50 20
002 A 20 5
003 B 50
004 C 60 10
005 D 40
006 E 90 15
........
If its 300 row from database to gridview it will show 50 record with page navigation..What i need is i need to insert data in to database table which gridview row has user value..The output of the another table(Table2) will look like this after insert
ItemNo ItemName uservalue
001 A 20
002 A 5
004 C 10
006 E 15
I have an inventory page with a gridview that shows 1 item per record, each item starts with a checkbox in the gridview. Currently users can select multiple records and hit the order button and everything has worked well. Now I have multiple pages in my gridview, and if a user selects a few records from the first page, and then goes to the second page, all the records (checked checkboxes) disappear from the first page.
[Code]....
I create reports sometimes with a gridview and export the data to excel. Lets say I have like multiple gridviews and I wanted to export each gridview to excel under its own spreadsheet.
So gridview1, gridview2, gridview3 are exported to excel under $heet1, $heet2, $heet3.
I know how to export multiple gridviews to 1 excel sheet but I don't know how to export them separately under their own spreadsheet.
I've been researching online, and i'm continously searching, but does anyone know how to do what i'm trying to do with the gridview and excel or is this not possible?
I m using a dropdownlist from sqldatasource based on input from listbox like this-
[Code]....
It works very much fine when i select listitem from listbox first time. But when i select listitem from listbox second time, my dropdownlist shows items for second input as well as first input.dropdown should not show items based on first input when i populate it second time.
I want to be able to show the record that was just inserted after add_button_click event. I run the insert from mycommand and then set mycommand2 to run the read to populate a details view. I have a feeling I am going about this the wrong way. The insert fires correctly but the details view does not populate.
[Code]....
I have been using Gridviews throughout a website I am currently building, however one particular requirement is to display two tables side-by-side that butt up against each other for the purposes of data entry. One person inputs numerous entries on the LH table whilst a different person will respond to one or more rows in any particular order (ie row 2 may addressed but row 1 might stay blank for a period of days). As far as I am aware, a GridView (or two) won't suit this requirement for the reason (from my still new understanding of GridViews) of not providing the ability for a 'respondee' to address any row in any particular order. Whilst I could add a button to each GriView row which displays a detailsView/FormView horizontally in line, I would still have to populate the Gridview with empty rows for those rows not addressed plus this 'fudging' just doesn't bode well concerning DB management.
It just seems adding two asp tables side by side then somehow working out how to automatically present a new row for data entry for the left hand table and creating a second table being the same size as the first (according to its number of rows) would be the way to go, then the task of data gathering/uploading to the DB. How best address the requirement - there maybe better ways for facilitating data input as opposed to using side-by-side controls, however it is the clients request. Also I don't want to go expelling copious amounts of time to fully customize a gridview when simply creating some sort of dynamic table would be sooo much quicker and easier for this once off. I have tried some searching, however not knowing where to start is problematic as 99% Google results return GridViews (as you would expect).