var debtProtectionId = 0
// get the selected id of debt protection dropdown
if (mainPanel.generalPanel.calculationsFieldSet.debtProtection.getValue() != '') {
debtProtectionId = mainPanel.generalPanel.calculationsFieldSet.debtProtection.getValue();
}
// get the store record with this id
var storeRecord = planCombinationsStore.getAt(debtProtectionId)
When I run the code it says 'storeRecord is undefined'.
I have a GridView with the following event:
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
foreach (TableCell c in e.Row.Cells)
{
c.Attributes.Add("full","false");
}
}
And in my javascript I have an onClick event for every cell:
if(source.full="false")
{
...
source.full="true";
}
else
{
...
source.full="false";
}
Why is it that source.full is always undefined on the first click?
What I want to do is to store new article and for each article choose a category..
I have 3 tables for example :
1. Article table : ArticleID - int , Article - nvarchar(max) .......
2. Categories table : CategoryID - int , CategoryName - nvarchar(150)
3. Article_Categories : ArticleCategoryID - int , ArticleID - int , CategoryID - int (And I set up relation in this table...)
I can store data into tables 1 and 2 that is working fine.. But I stuck with Table 3.
So far my code looks like this :
protected void Button1_Click(object sender, EventArgs e) //Add new Category (working fine)
{
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string insertSql = "INSERT INTO Categories(catname) VALUES(@catname)";
[code]....
I have 5 radiobuttonlists and 5 checkboxlists and all are the product parts.I have table parts this values:
polecart_parts
productid
productname
productgroup
productvalue
productprice
sku
description
All radiobuttonlists and checkboxlist popluate from the database.comapring product productgroup and productvalue.after customer seleted items from these radiobutton list and checkboxlists iwant to create it as record to sttore in diffrent table with the all selected item + total price.so that in future we just serch record and we get it with and induval price and total price and seleted item.also its show image on selted items too.I dont know how to do it , I have MS ACESS database.I am using C# asp.net.I am working on it since last week.I dont know how i start it. I want to show image when it retrive the record which is customer seleted.
We have a site running FW 2.0 on IIS 6. Actually two sites (on the same server), one works and one has that little Done with errors note in the lower left. The errors are 'Sys' is undefined & WebForm_SaveScrollPositionSubmit' is undefined. I have cleaned the bad site, copied the code from the good site, including web.config, and still see the problem. This was working for a number of months, then I guess we didsomething, and now the errors.
View 2 RepliesI have one SqlDataSource control as DataSet with enable caching in one page aspx. Filtering is applied to this SqlDataSource control, so that the page always returns one record data.
My question: How to get the record data value from SqlDataSource control (one record data value) and store it as String variable?
In my online web-application User is inserting new records and when user enters record system gets current datetime (using below query) and insert into table.
INSERT INTO Gponmig(Customer_Name, Contact_Mob_No, Sector, Plot, flat, Building_LandMark, Sr_No, Adsl_Acc_No, Del_Acc_No, Mig_Requirment, Reseller, Sales_Remarks, Userid, Dept, Date)
VALUES (@Customer_Name,@Contact_Mob_No,@Sector,@Plot,@flat,@Building_LandMark,@Sr_No,@Adsl_Acc_No,@Del_Acc_No,@Mig_Requirment,@Reseller,@Sales_Remarks,@Userid,@Dept,
GETDATE())
Problem:
User entered data at 12:27 PM but system recorded 12:27 AM.
I couldn't find why?
It is confirmed by the user that he didn't worked midnight.
Required:
The system should insert correct time.
My insert is adding a record to the database in the call to the stored procedure in SQL Server, but a -1 is returned - Shouldn't it return 0 if the insert/update was successful?
Result = myCommand.ExecuteNonQuery();
Using SQL and C#. I have a gridview with a template field. I need to modify the some items in the gridview when the user selects a given record and store the values back in the database. ProjectID is the unique key in the database.Gridview is done as a table. How can I do it? Here is my grid view implementation.
[Code]....
My SQL stored procedure returns 3 different datasets as follows:
team_id name
1 Team1
2 Team2
...and more
location_id name
1 Dallas
2 New York
...and more
branch_id name
1 Austin
2 New Jersey
...and more
How do I put this data into one Dataset so that I can loop through the data and manipulate it?
hey folks I got a general question that maybe some of you can just weigh in. I developed an online store for a client and people place orders online for a food ordering place however I am trying to find the best way to have the orders show up for them at the store. Currently I am sending an email and an autoprint software prints it out which works most of the time but not good enough sometimes it doesn't print. Anyone had similar issues or have other alternative solutions you may have heard off? Like I said the site sends an email to the customer and the store's email account.
View 7 RepliesI am using paging to my gridview (pagesize=4) . now i am in (X) page and i want to get (X+1) page top record or (X-1)page bottom record , how i can get .
View 2 RepliesI have a delete button bellow my gridview and I want a pop up to show when no record is selected and tell the user to first select a record. The button click event would show the pop up, but my gridview data blanks out.
Here is my code:
[Code]....
I'm very new on VWD, but I got the hang of it for the past 2 weeks(thank you for all the videos posted here in ASP.NET),but I'm really weak on the coding part(vb & c#),except for all the sample shown on the tutorials. Anyways, I have a simple project that
does insert, update & delete to SQL express using the details view. But to complete my project, I need to add a button that will create an event to restore the very last record inserted in SQL and display it back into the details view for minor modification
and nserted again as the newest record with the mod. I'm doing this so user, doesn't need to re-key-in redundant information, like names, original date & time etc, and just make modification on the description of the last record.....
I am counting from a table for that i have written code as below
protected void get_Id_Afterpoint()
{
int counter = 0;
string strSql = "select count(*) as ID from tblEnergy where ID=?";
OdbcCommand com = new OdbcCommand(strSql, con);
com.Parameters.AddWithValue("ID", DropDownList1.SelectedValue);
OdbcDataAdapter oda = new OdbcDataAdapter(com);
DataTable dt = new DataTable();
oda.Fill(dt);
if (dt.Rows.Count == 0)
{
lblID2.Text = "1";
}
else
{
counter = dt.Rows.Count;
counter = counter + 1;
lblID2.Text = Convert.ToString(counter);
}
}
there is no record related to DropDownList1.SelectedValue. but as i am counting if(dt.rows.count) and i put break point on the bolded part it shows 1 record. how it can be possible?
I want users to select a record in the GridView and then have that record open up in the Detailsview. How would I go about getting these two tools to communicate?
View 4 Repliesi have design a web application having suppliers table using SqlDatasource..
i have a master page in my design and other form are bound to a context menu..
Now i have displayed the records in the gridview..all i wanted is after i select a record in the gridview it will display the selected record in detailview from another aspx form..
i was able to create the link to another aspx form but the data that it display is the first data from the gridview not the data that i select.
i have one parent grid on which if user clicks a record ,the child details should get displayed on same page.
for example :
There is one department details table and employees table:
if user selects a record in department details grid,then employees in the selected department should get displayed in the next grid in the same page
How to Call a record on datalist by button click and display record on formview in model using Username
Here is what i tried
<asp:DataList ID="GetMergedAll." runat="server">
<asp:Label ID="Name" runat="server" Text="Label"></asp:Label>
<asp:Label ID="Post" runat="server" Text="Label"></asp:Label>
<asp:LinkButton ID="LinkButton6" runat="server">LinkButton</asp:LinkButton>
</asp:DataList>
protected void Page_Load(object sender, EventArgs e)
[Code] ....
HTML
model here
<asp:FormView ID="Post" runat="server">
<asp:Label ID="Name" runat="server" Text="Label"></asp:Label>
<asp:Label ID="Post" runat="server" Text="Label"></asp:Label>
</asp:FormView>
I was Make code to select top 3 record from db and I wont to enter every record in label or textbox
[Code]....
I am creating an album using the following stored procedure, which returns the primary key for the newly created record:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[fpa_sp_albums_update_insert]
@album_id int,
@album_name nvarchar (50),
@album_descr nvarchar(250),
@album_img_cover_id_FK int,
@album_creation_date date
AS
If @album_id > 0
UPDATE [fpa_albums]
SET
album_name=@album_name,
album_descr= @album_descr,
album_img_cover_id_FK = @album_img_cover_id_FK,
album_creation_date = @album_creation_date
Where ((album_id = @album_id))
Else
INSERT INTO [fpa_albums] (
album_name,
album_descr,
album_img_cover_id_FK,
album_creation_date)
VALUES (
@album_name,
@album_descr,
@album_img_cover_id_FK,
@album_creation_date)
Return SCOPE_IDENTITY();
I execute the above stored procedure using the SQLHELPER. The VB.NET code for the page is as follows:
[Code]....
However, the createdAlbumID always shows -1 instead of the id for the newly created album.
I'm using a details view and a sqldatasource control to populate it. Every once in a while i get an error message because more than one row is returned. How can I have the data display in a gridview instead if more than one row is returned?
View 1 RepliesWe have developer project in Visual studio 2008, Using Ajax and telerik Rad Controls.
In IE 8 And Firefox, Chrome, Opera Everything is Working fine...
but In IE7 and IE6 It is throwing 'Sys' is undefined Error... And Everything looks Collapsed.. Css, Images Are not displaying on the page..
What is the cause of this error: "RSClientController is undefined"? It is associated with a ReportViewerWebControl displayed on a ASP.NET page.
View 1 RepliesI have the following code, for testing im just writing the list to the page, but noticed that its missing the first record from the results. When i execute the procedures on the database, they return the correct values, so i know that part is working, the
next part is for records that should be returning 1 record, the arraylist is empty, even though it should return1 record. What am i doing wrong with the code below? ( gratssec is a class that contains the procedures we are using.
[Code]....