What i want to do is read from a database where the catalog = 12 and then have a button on the page to add a new catalog named 13 so it takes the 12 and adds 1 to it so everytime they click the button they will get a message saying "are you sure you want to create anoter catalog?" and if yes then it executes.
View 5 RepliesWhich is the best platform to create a gadget that pulls data from a database.
View 8 RepliesI have scanned the web, and see things but nothing clear to me.
View 4 RepliesI have been banging my head against this problem for a bit and I think I am stuck. I would like to pull data from a Database to populate a list of possible "clients" to select from on one side. Then using what has been clicked load the client specific data into a tab container on the opposite side. I plan on doing lazy tab loading so I am not sure if that matters. I am really stuck and any help or guidance anyone could give would be greatly appreciated! I understand the basics of data loading and of tab containers, but i am unsure of what to do. I am coding this in C#. Example Mock Interface This is where the data list would be and I want to be able to select something here And update the Tab Panel control here based on the selection from the left side via querying the database.
View 3 Replieshow to create a increment using ajax timer? Which mean in ajax timer with a tick int i will increase by 60. E.g. 1st tick from 0 to 60, 2nd tick from 60 to 120, 3rd tick from 120 to 180, continue...
View 9 RepliesI use SQL Server and when I create a new table I make a specific field an auto increment
primary key. The problem is some people told me making the field an auto increment for the primary key means when deleting any record (they don't care about the auto increment field number) the field increases so at some point - if the type of my field is integer for example - the range of integer will be consumed totally and i will be in trouble.
So they tell me not to use this feature any more.The best solution is making this through the code by getting the max of my primary key then if the value does not exist the max will be 1 other wise max + 1.Any suggestions about this problem? Can I use the auto increment feature?I want also to know the cases which are not preferable to use auto increment ..and the alternatives...note :: this question is general not specific to any DBMS , i wanna to know is this true also for DBMSs like
I want the user to click the link then the window pops up, but I want the data inside the window to be pulled from a database, and I need to repeat this process for 5 links that are also pulled out of a database. Say the most popular items for the month. My question is how would this be best accomplished? Jquery, or AJAX. I am just trying to see which would be the easier way to go about coding this with .net and C#.
View 1 Replies i'm working on my first project on asp.net using c#.
I'm adding a couble of fields to database but i need the primary key of the master table to add it to sub table.
The database contains 2 tables :
Question Table :questionID(primary key and identity) , questionInText
Answer table : answerID , answer1,answer2 , questionID
code used to insert to db :
[code]....
I was put in charge of a database that has no source control, and all work was done in the database. I want to pull all the objects (stored procs, views, tables) from the database, and add to my new source control.
Is there a way to get all the objects into individual files out of a database?
Our database is SQL 2005. I have Visual Studio 2005/2008/2010 (beta 2) at my disposal.
I have content that I want to load dynamically, the problem is it has some html formatting in it. What control should i pull the text into, is there a way to pull the text into a div or a label, along with the formatting?
View 1 Repliesauto increment alphanumeric primary key(eg :ABC001) in sql server 2005 database table.
View 2 RepliesWhen a user logins, I want to be able to store all his profile information so I can display, for example, his email on different pages of my website, but I don't want to have to keep querying the database for every time I want to display his email. How would I go about doing this?
View 2 RepliesOn a test page, I successfully created a google map that pulls both marker and infoWindow information from an XML file. I did this just to get a feel for working with the API. It works fine. However, I do have a SQL database that has this information in it already. This database is updated behind the scenes regulary via a webservice.
I would like to try pulling the map information from my SQL database instead so I don't have to hand maintain the .xml file. The dabase alread has the lat/long information needed for markers. What is the easiest way for me to get that data from the SQL database? Is there a way to run a query and use the data, or will I need to run the query and somehow have it write/update my .xml file for me?
I need to pull the data from DB and fill the view model, is there any better way to do this? Currently I'm doing something like this.
ViewModel vm = new ViewModel();
var recentBill = context.Money.Take(10);
foreach (var r in recnetBill)
{
vm.lst.Add(r);
}
I'm rather liking this MVC3 and Razor way of working and I'm learning the ropes. I was wondering, can I create a partial view and pull it into another view in the following scenario:I have a "Person" model and an "Address" model. The Person contains name, phone number etc and each person has an address. I've created my Person "Create" view and that works fine but I now want to pull in my "Address" partial view to it.
View 10 RepliesI have a major problem. I have windows 2003 serverm in it I have installed sqlserver and on it several databases that was published for months. Now, the windows 2003 server crashed and I cannot login ti windows anymore. What I have done is to create a new installation of windows and installed again the sqlserver...
Now, how do I get back the latest database from the previous corupted installation? I still have access to the files in the previous installation.
I have a text box, if i have 1.00.
Then in the textbox1.text it should be 1.01
if i have 1.01 then it should be 1.02
How to increment 10th of a decimals by 1.
i want to add an increment id at the place of Lead_ID
<img src="http://track.opicle.com/aff_l?offer_id=2193&adv_sub=Lead_ID" width="1" height="1" />
C# code/form code -
When I submit my form than GenerateNewCID() is not increase continuously it repeat same ID every time as below -
16020001
16020001
16020001 ...
But is want it in the form of below -
16020001
16020002
16020003 ...
//code behind//
private string GenrateNewCId() {
string newCId = string.Empty;
string prefix = DateTime.Now.ToString("yyMM") + "0000";
string selectedIdPrefix = prefix.Substring(0, 4);
int curCId = Convert.ToInt32(prefix.Substring(4, 4));
[Code] ....
i was given a form in which empid is varchar and i m supposed to auto increment it using a function and calling it ....i have never done this. plz help me out the way .
View 9 RepliesI want an auto increament using stored procedure how can I do this process. I want a reference number in this procedure ...
ALTER PROCEDURE [dbo].[Emp_Detail] (
@Name varchar(max),
@Emp_No varchar(50),
@Job_Title varchar (max),
@Nationality varchar(50),
@Administration varchar(50),
[Code] ....
why i could not get 3 at Label2.Text even though i fulfilled the conditions under the if else statement?Is it because counter1 can only be use for one condition
if ((check == true) && (lblQuestion.Text == "1.1"))
{
Button1.Visible = true;
Label1.Text = "You have got it correct, please try the next question.";
Button1.Text = "Next";
[Code]....
How can I autoincrement the value of a boundfield column in a gridview ?
View 2 RepliesI have a primary key in a database that I present to the user.the key is made up in the format SUBJ0001 and needs to increment to SUBJ0002 etc as new entries are made. I have currently presented the user with the last entry and am relying on them to increment this value in a text box. How would i go about incrementint this through code.i could split out the SUBJ part but I cannot convert 0001 to an int and increment and convet back?
View 4 RepliesI want to use a function in the code file of ASP.NET such that everytime the function is called, its value increases by 1.I thought of a way but it didn't fully work out. I created a class for this and used a static variable in that but the lifetime of static variable in asp.net is till the time the app does not close.
public class Class1
{
public Class1()[code]....