I have an updatepanel that contains gridview which displays the records from DB. I want to create something that allows this grid to be automatically updated when a new record is inserted in the table. i don't want to use Timer control to refresh the page on set intervals. Is there any other way of accomplishing this.
View 3 RepliesI am using the ajax popup for inserting some details. When you click on a Save button on the web page, a window pops up (ajax Modal popup) and once you enter the fields in the popup and click submit button in the popup, all the fields in the webpage and the popup window should be inserted into a sql table. I wrote a sql stored stored procedure for this.This is the way i did but the details are not being inserted into the SQL table.
View 6 Replieshave a dropdown list box in the jquery grid, i have two values, Yes and No,,on selection on dropdownlist I need to update the column in the database...using asp.net mvc control
View 1 RepliesHow to go about creating a grid/table that can updated at run time by the user and can also be printed and exported to Excel. I have the print function working and I know how to export datagrids to Excel. Im going to attach an example to explain more clearly what Im looking for. Is this possible with a datagrid?
View 5 RepliesI setup my gridview to handle the edit,delete, and insert operations correctly. My grid also supports paging and sorting. My question is how to highlight and go to the newly inserted row in my grid?
View 1 RepliesI have code but the
div.Visible = true; textbox1.Visible = true; are not visible
Secondly the b1 click event happens only once, if I again click the script does not get executed
function MouseUp(e) {
document.getElementById('b1').click();
}
protected void btnpb_Click(object sender, EventArgs e) {
[Code] ....
I have 2 grids side by side.
What I need to do on RowCommand of Grid A is to refresh grid B with ( SELECT * FROM <ChildTable> where FK = GridA.PK )
Ideally I would like to do this without a full postback because I could do with preserving my position in grid A.
This is my coding
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtUserFilter" runat="server" AutoCompleteType="Disabled"></asp:TextBox>
[code]...
I have a reports table with column report id and and report version. I created a trigger on this table to execute an application to do some processing each time a row is inserted in reports table. I need to pass the new report id execute this application from the trigger. How do I get the report id from the row that was inserted?
View 1 RepliesI have an ajax modal popup extender in update panel. The modal popup extender has a label, checkbox and a dropdown list. When i open the popup first time (i.e Page_load) and select something and click on ok the data is populated correctly in another grid. If i open the popup second time and select some data and click on ok it is populating the grid with the current selected data as well as previously selected data.
View 3 RepliesIn oracle we can do this by using rowid.
select * from tableName where rowid = (select max(rowid) from tableName);
but i don't know equivalent of rowid in sql server.
as seen from the title my sql doesnt update the data that has been inserted by my function. But in my function it works perfectly as it returns '1' when i executenonquery. however it only works when i insert a record which has a date later than today's date. which is weird as there is no validation in that page and if there were to have a validation, it would not run the function.
View 10 RepliesI have this image upload code...that works....but I need a code to get the Id of the image that i just uploaded..
Protected Sub ImageButton_AddImage_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton_AddImage.Click
Dim IntLength As Integer
Dim ArrContent As Byte()
[Code]....
I have an SQL Server table named "Fields" with an autoincrement identity column "FieldID" as the primary key, an nchar column "Phrase" that textbox entries are to be stored in from a web page, and another column that is defaulted to null. The following is the recommended example on how to use Scope_Identity() to get a newly inserted table row identity value:
//C#
string query = "Insert Into Categories (CategoryName) Values (@CategoryName);" +
"Select Scope_Identity()";
int ID;
string connect = @"Server=.SQLExpress;AttachDbFilename=|DataDirectory|Northwind.mdf;" +
"Database=Northwind;Trusted_Connection=Yes;";
using (SqlConnection conn = new SqlConnection(connect))
{
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@CategoryName", Category.Text);
conn.Open();
ID = (int)cmd.ExecuteScalar();
}
}
Obviously, this example uses a Categories Table in a Northwind database, which I do not have. So I am confused by how to adapt this example for my application. The following is my data context:
DataClassesDataContext db = new DataClassesDataContext();
Could you explain how I can adapt the example for my "Fields" table in my "EFMDB" database?
I am having a table named Invoices.From that table I want everything the newly inserted and updated rows from that table.
View 3 RepliesI have a table which has one row and only one cell will be editable. I have accomplished this with the following code.
$("td#effEndDate").click(function() {
if (!$(this).hasClass("edit")) {
var value = jQuery.trim($(this).html());
$(this).html("<input id="txtEdit" type="text" value="" + value + "" />");
[code]...
I am using LINQ to store and retrieve data from tables with a clustered index key. However, I also need to know how to obtain an inserted table row identity with an auto-increment Primary key. The "Go To Definition" feature for my data context of dataClassesDataContext provides the following information:
[System.Data.Linq.Mapping.DatabaseAttribute(Name="EFMDB")]
public partial class DataClassesDataContext : System.Data.Linq.DataContext
I am asking for the C# code that is needed in a button click event handler that will insert a row of data in a table named "Fields". It only consists of an auto-incrementing primary key column (FieldID), a string column (Phrase) and a null defaulted variable column.
I have data entry form like...There are some empty rows and some of them have values. User can Update existing values and can also fill value in empty rows.I need to map these values in my DB table and some of them will be inserted as new rows into the database and existing record will be updated.I need your suggestions, How can I accomplish this scenario with best approach.
View 2 RepliesIm upload a file using file upload control and for unique identificaton
we use system.io.file.GetCreationTime(Path).Tofilename()
In local system the file is inserted in to the table and local folder - with 18 digitnumber +filename.
But after publishing, when we run, the files are inserted into the table without the 18 digit and error occured.
In my webform, i have 3-4 textbox, on there textchange event i have to fetch data from database and put it on the form. I have taken another html table (with runat="server") below textbox and and in textchange event created a new <tr>, <td> and simply added contents in <td>, then finally added <tr> in the table. This is done in UpdatePanel.
When i enter something in textbox1 data is added in that table,that's fine. But when i enter something in 2nd textbox the previous data is overridden. My requirement is that if 2nd textbox's text changes than another row with appropiate data should be added, i.e., now two rows. Silimarly if 3rd ,4th textbox data changes then subsequently 3 or 4 rows should be displayed.
I have a table in orcale database where I am inserting records. I am able to insert a record in a table but it is not being saved permenantly.When inserting there is no error. what could be causing this?
View 4 RepliesI'm needing to get the selected rows, based on checkboxes, to insert into a different table than that that the gridview is formed from. I've created an innerjoin datasource to try and solve this but, still having problems finding something that works. I also need it to insert based upon a button click not inside the gridview as I believe otherwise would only hamper the situation more.
View 7 Repliesi want to add (Edit(update/cancel) and Delete like Gridview) button in html table and perform edit and Delete operation using jquery and Webservices ?
View 1 Replieshow to asp.net update panel use in Tree view and grid view
View 2 Repliesin my application i have tab container with several tabs, inside everyone of them
i have textboxes, dropdowllists etc. i want to get those values filled by the user,
how can i do this, the intelisense don't recognize them.