C# - Checking If An Item Exists Before Saving?
Feb 2, 2011
I've a SQL DB with various tables that save info about a product (it's for an online shop) and I'm coding in C#. There are options associated with a given product and as mentioned the info recorded about these options is spread across a few tables when saved.Now when I come to edit this product in the CMS I see a list of the existing product options and I can add to that list or delete from it, as you'd expect. When I save the product I need to check if the record already exists and if so update it, if not then save a new record. I'm trying to find an efficient way of doing this. It's very important that I maintain the ID's associated with the product options so clearing them all out each time and re-saving them isn't viable unfortunately.To describe again, possibly more clearly: Imagine I have a collection of options when I load the product, this is loaded into memory and added to / deleted from depending on what the user chooses. When they click 'Save' I need to check what options are updates and what ones are new to the list.
View 3 Replies
Similar Messages:
Jul 6, 2010
how would i check if the file path already exists in javascript
View 1 Replies
Feb 28, 2011
I'm trying to error handle a registration aspx/c# page on my application and want to run a check whether the email address that a user has tried to register already exists as the email address is used as a primary key in my database.
I have tried IF NOT EXISTS/IF EXISTS but these dont give the desired effect so was wondering if there was another way around it?
View 2 Replies
Mar 24, 2011
I have a ASP.Net website with links to files stored on a file server. These files are modified constantly and so the links will not always be valid, this includes changes to permissions, files being moved or deleted, etc. I implemented a method in the code-behind to check the validity of these links as they are constructed, if it fails the code will add CSS to change the color of link:
Check URL
/// <summary>
/// Check if a URL exists. Method by http://www.vcskicks.com/check-website.php
/// </summary>
/// <param name="url">URL to validate</param>
/// <returns>True if the URL was resolved, false otherwise</returns>
[Code]....
My problem is that not all the invalid links are getting the style added to them. The strange thing is that when I step through the method in debug mode using one of the bad links that was not colored, the method will return false and color the link as expected. There's a lot more involved then what I present above, but I searched the entire aspx code-behind for any other locations where the link url is being set and couldn't find any. I don't know if there's some post processing going on that somehow clears any styles that were applied to some of the links. The fact that some links are colored while others are not is very confusing to me. Has anyone else encountered similar behavior before?
View 1 Replies
May 11, 2010
backfolder1=\systemnamefoldername
If
Not Directory.Exists(backfolder1) =
True
Then
Directory.CreateDirectory(backfolder1)
End
If
i am using the above code
but even if the folder exists it creates the directory
View 6 Replies
Oct 27, 2010
I use a ItemDataBound for a repeater.But i use 2 kinds of linq querys to bind it.Some of them has a MerkID, and some doesnt have this item.So its easy i need to do this:
if(e.Item.DataItem.Contains("MerkID"))
{
//Code for linq query 1
} [code]...
So of course the if selection doesnt work, but how can i do that? I already tryed this:
DataRowView drv = (DataRowView)e.Item.DataItem; if (drv.Row.Table.Columns.Contains("MerkID"))
But that doenst work because he cant convert it to a datarowview because its a linq class.So what to do? Right now i use a try and catch, but there are better solutions i guess...
View 8 Replies
May 7, 2015
according below thread I change file name when users upload from file upload control:
[URL]
below is my code that I changed
if(this.fuppdf.HasFile)
{
string path = Server.MapPath(".") + "../image/House/article/pdf";
[Code]....
if file name be duplicate it add 1 at the first of file name but here it doesn't work I mean when I upload file i.e catalog.pdf ("catalog is the text in txttitle) it saves in the host with this name catalog.pdf
but when again I want upload catalog.pdf in host it overwrite last (catalog.pdf) but I want if there was catalog.pdf file it saves with this name 1catalog.pdf in host
View 1 Replies
Aug 30, 2010
I have a grideview and 2 buttons. I need to only show the buttons when the gridview has a selected item. My code looks like this:
protected void Page_Load(object sender, EventArgs e)
{
btactivate.Visible = false;
btdeactivate.Visible = false;
//Show Activate and Deactivate Buttons only if an item in the gridview is selected
if (GridView1.SelectedIndex != -1)
{
btactivate.Visible = true;
btdeactivate.Visible = true;
}
else
{
btactivate.Visible = false;
btdeactivate.Visible = false;
}
}
But the problem I have now is that only when I select the second time a item in the gridview the buttons show up. I need to have the the buttons show when I select the first time. I have tried changing the selected index to "-0" but that shows the buttons all the time (even when I dont have something selected).
View 1 Replies
Jul 21, 2011
I am binding Dropdownlist from sqldatasource. Is it possible to check conditions with Dropdownlist on each item bound, based on the select command.
Code:
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SQLDataSource1" DataTextField="emp_name" DataValueField="emp_id"></asp:DropDownList>
<asp:SqlDataSource ID="SQLDataSource1" runat="server" ConnectionString="<%$ConnectionStrings:ConnectionString1 %>" SelectCommand="select emp_id,emp_name,status from emp_master"></asp:SqlDataSource>
In this example code, when binding if the status of the employee is OffDuty then it must be highlighted in DropDownList.
View 3 Replies
Aug 10, 2010
I am trying to show the user of my application that when they click on a menu item that their selection gets shown by changing the background color of that menu item
I am using the default menu that comes with asp and is contained in the site master. the default CSS for the menu has a hover and active properties but only the hover works.
View 11 Replies
Jan 18, 2010
I am having 2 list box in my form. I am adding some values from 1st list box to 2nd one. What i need is i would like to save the data in the list box in sql table.
View 6 Replies
Dec 13, 2010
I would like to check whether a folder exists or not if not create. I'm sure this folder exists, but for some reason I get "false" when I check with "Exists" method.
The only reason I think could be because of the W: drive? I moved this application to production site and even there it returns false.
while I'm type in Windows explorer on my localhost and on the server "W:/Webs/ASPPages/cropper/uploads" it opens this folder. So my localhost and IIS server has W: mapping.
for test I tried to create the folder then it says can't find the path...
userFolderName = @"W:/Webs/ASPPages/cropper/uploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried "W:\Webs\ASPPages\cropper\uploads"
DirectoryInfo dirInfo = new DirectoryInfo(userFolderName);........
View 3 Replies
Jan 27, 2011
I am saving grid data. Grid contains one textbox in item template column. But it was not saving any data, which was entered in textbox(Just saving 'NULL'). There was not error while debugging. Below is code i am using.
[Code]....
View 2 Replies
Aug 22, 2010
This is the Grid am using ....
[Code]....
Every thing is working fine ....
Wat i did is in the first header of gridview dropdownlist i have binded the PO Item , so that user can select item n make invoice...
Here the problem is user will click addnewrow button to create new row second row , again user is able to select the same item what he selected in first row of gridview. here how to avoid duplication in the second row .
Say i have four PO item
Item1,Item2,Item3,item4
user may select Item1 in first row , after clicking addnewrow button user will get second row
here again user is able to select Item1 from dropdownlist ... how to avoid duplicate selection
coz the dropdownlist is binded from database using sqldatasource n filter based on user selected PO no.
Duplicate Item selection should be removed until all the four item is selected ...
View 1 Replies
Mar 24, 2011
I am using aspnet menu control and i want to hide the item initially on page load and show the item after an event is trigger say button lick event Can any one give me an example?
View 6 Replies
Feb 10, 2010
I have a list with 2 sorts of items. Items that have actual values (1,2,3,4 etc) and items that are like group headings so all their values are set to 0. If someone decides to select a group heading - which has a value of 0, is it possible to redirect them to my 'Select an item' item which has a value of ""?
If worse comes to worse, I can just reconstruct the entire list, although if possible I'd like to avoid it.
View 4 Replies
Jul 7, 2010
I have a project that queries a set of times from a database and uses these entries to populate a dropdownlist. Once the page is loaded, the user can select one of the items in the DropDownList. When the "Save" button is clicked, the Selected item value is returned to the [HttpPost] version of the controller action. This item is then stored into session. If the system returns to the page containing the dropdown, I want the saved Value to be selected in the DropDownList. What actually happens is that the DropDownList is always set to be the first item in the list.
Database Table: This data has been imported using Link to SQL
[code]....
View 4 Replies
Jan 17, 2014
How can I get current viewed itemindex of a repeater item template, have tried a few stuffs i got from google search, but it seems not to work.
I have items like:
1 text link1
2 text link2
3 text link3
4 text link4
where 1, 2, 3, 4 are the itemindex, i want to be able to get 1 if text link1 is clicked, or 2 if text link two is clicked etc.
Here is my repeater html
View 1 Replies
Aug 31, 2013
Error 1 'System.Data.OleDb.OleDbDataReader' does not contain a definition for 'Item' and no extension method 'Item' accepting a first argument of type 'System.Data.OleDb.OleDbDataReader' could be found (are you missing a using directive or an assembly reference?)
public partial class Default2 : System.Web.UI.Page {
System.Data.OleDb.OleDbConnection Con = new System.Data.OleDb.OleDbConnection(System.Web.Configuration.WebConfigurationManager.
ConnectionStrings("MyConnectionString").ConnectionString);
protected void Page_Load(object sender, EventArgs e)
[Code] .....
View 1 Replies
Jul 16, 2012
I bind dropdownlist in my page
protected void Page_Load(object sender, EventArgs e) {
BindDropDownList(DDL1, "city1", "name", "ID");
DDL1.Items.Insert(0, new ListItem("select city", "0"));
}
And SP
LTER procedure [dbo].[city1]
as
begin
select id,Name
from city
end
And design code
<asp:DropDownList ID="DDL2" runat="server" CssClass="daddsd">
</asp:DropDownList>
And here is imagebutton code that when click on it update data into table
protected void ImageButton_Click1(object sender, ImageClickEventArgs e) {
string data = Server.UrlDecode(Request.QueryString["BehCode2"]);
SqlCommand _cmd = new SqlCommand("insertinfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[Code] ....
Here when i click on button it insert all data into table but it didn't insert my selected item from dropdownlist it insert select city that i define in page_load
DDL1.Items.Insert(0, new ListItem("select city", "0"));
And when i delete this code from page load it insert in table first row of my table it didn't insert my selected item from dropdown list.
View 1 Replies
Oct 6, 2010
I have a repeater control:
<asp:Repeater ID="rep" DataSourceID="XMLDSCompare" runat="server">
<ItemTemplate>
<h4><%# XPath("title")%></h4>
</ItemTemplate>
</asp:Repeater>
Now if its the first item in the total resultset, I want to add <div> to ItemTemplate control, if its the 2nd item, I want to add </div>
So output would be (not including table tags generated by repeater control):
<div>
title 1
title 2
</div>
<div>
title 3
title 4
</div>
<div>
title 5
title 6
</div>
How would I do this in the ItemDataBound event of repeater control?
View 6 Replies
Jul 4, 2010
I am trying to get a drop down and a form view to work together. I've never used form views before. I also am using the entity framework to do everything. This is also my first time with it.
I want to be able to have a drop down, that is populate from the same data source as the form view. So far that works fine.
I then want to be able to change the drop down item, and it change the form view item that is displayed. I cannot figure out how to make this work.
View 3 Replies
Feb 3, 2010
i use a dropdownlist in a page, with its items taken from a mysql database
i also use autopostback property...my problem here is that, every time i selecct an item, the first item in the list gets seelected
View 5 Replies
Nov 7, 2010
[Code]....
here the method OnItemDataBound , look at how it work
[Code]....
problem is the e.Item always get one and only one last item . turn out my listview display many rows but with a consistent content of the last user (in the database record) . How can i resolve this ?? any creative method are accepted , i'm just want to finish this project
View 2 Replies
Aug 12, 2012
I have 2 dropdownlist in my page
1-ddlzone1
2-ddlstore1
What I need is if I select default item i.e. 0 in Zone dropdown I need to show all items in store dropdown. Below is my stored procedure to get the stores
ALTER procedure [dbo].[selectcenter]
@RegionID varchar(5)
as
begin
select ID,Centername
from Shoppingcenter
where RegionID=@RegionID
group by ID,Centername
end
View 1 Replies