I am having a field called Semester, i will enter it as 1 initially. Then it should automatically increase 1 semester every six months till sixth semester in the database (sql server 2005) is it possible?
View 5 RepliesI really need to create ID like this. But I don't know how use this Procedure .If you don't mind can you explain to me step by step how to use to procedure for create auto ID in database. (Should I call to this Procedure from somewhere else, like webpage button or something)
View 4 RepliesI have project in asp.net with sql server backend.i want to auto generate a number for particular column.with the auto generated number i want to insert some other data in the same row same table. on button click event.details
railway PNR no.:- want to autogenerat
passenger details:- want to inserted simultaneously
How to generate a employee code in textbox automatically while in run time in web application.......when i run the page it will check the employee code in the database and it automatically shows the next value in the textbox how?
View 1 Replieshow to edit data in grid view manually without auto generate in gridview + ajax.
View 4 RepliesIndex outof range?GridView2.Columns[6] as BoundField I use Auto-generate field .
How to manipulate GridView2.Columns as BoundField with auto-generate field?
[code]....
My GridView uses auto generate Edit & Delete command button. And then program the insert button. I want to do something when users click the Edit button so I wrote something like this:
[Code]....
When click the Insert button in the Footer, the program works fine. But when trying to click the auto generate Edit button, the following statement failed with the exception stated in the code above:
first_name = gvAgent.SelectedRow.FindControl("txtEditFName")
I've got a MS SQL (Express) database. its quite complex and uses a lot of tables. Is there a way to generate a SQL script for creating the complete database, but not the content of it.
I like to copy the database. Right now i copy the database. After that i need manually to clear all fields. There are also some relationships, so its a lot of work to clear all of it manually.
I am generating a unique Ref number using this sql statement: SELECT REPLACE(STR(CAST(CAST(NEWID() AS binary(5)) AS bigint),12),0,0) as REF Subsequently, I need to insert this REF into sql database table in stored procedure. Here is what I did in my stored procedure:
USE [iBankRecords]
GO
/****** Object: StoredProcedure [dbo].[stp_addPayee] Script Date: 07/05/2010 21:57:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[stp_addPayee]
(
@CUSTID char(10),
@PAYEEACCNUM nvarchar(20),
@PAYEEACCTYPE char(10) ,
@PAYEENAME char(20),
@PAYERINITIAL char(20),
)
AS
DECLARE
@ReturnValue int
INSERT INTO PAYEE (CUSTID, PAYEEACCNUM,PAYEEACCTYPE,PAYEENAME,PAYERINITIAL, REF)
VALUES (@CUSTID,@PAYEEACCNUM,@PAYEEACCTYPE,@PAYEENAME,@PAYERINITIAL, REF)
IF @@ERROR<>0
BEGIN
PRINT 'ERROR'
SET @ReturnValue=1
RETURN @RETURNVALUE
END
ELSE
BEGIN
SET @ReturnValue=0
RETURN @RETURNVALUE
END
May I know how do I have generating a unique ref num and inserting the REF into the above statement?
I am trying to generate a Grid view from database, in one of my database columns the values are 'y' and 'N'. and i need to show this values in a check box .I tried to keep a check box in item template and tried to bind it, but could get much success.
[Code]....
How to generate script from a database with its data? I tried it, but it was not generated with data.
View 13 RepliesHow can I generate a script which contains all database tables, stored procedures, data, and etc. ? So that I can
use this script to create a database on the new server.
I am using MS SQL 2005.
object og = GridView_EmployeeTimeSheet.DataSource;
System.Data.DataTable dt = new System.Data.DataTable();
dt = (System.Data.DataTable)og;
But getting null in og(object) and at run time Gridview is showing its required data...
I am creating a attendance database table in sql server2005.. i just want to generate the gridview as follows in form.aspx.. i am using vb.net generate the report in gridview..
Attendance table
employee name(varchar)- Its contain all the employees name
date(datetime)-Its contain dates
status(varchar)-Its contain the status of employee whether they are Present or Absent
I just need all the employee name (data) in one rows and dates in columns.. also i need the status of the employees inside this.. whether they are absent or present.
I used visual studio 2008 and sql server 2005(for database) in my website project. After finishing my project i used publish to web option and got the files into an folder. I have installed .NET framework ,IIS, i have also set the remote connection ,firewall setting etc. But when i run i.e., In the IIS manager when i click browse it gives me the following error. Can anyone pls tell me what went wrong in this. My code works fine when run on visual studio 2008. Server Error in '/EBUSINESS' Application.
View 1 RepliesI have a "database explorer" page that is desgined to be pointed to an unknown database and allow users to browse the data, so it basically uses the SQL system tables to develop its queries and pull in data to tables using auto-generate columns.The problem that I have is that I would like certain types of columns to have certain formats and I'm wondering the best way to go about it. I could format the column in code in the RowDataBound event I assume, but I'm wondering if there some better standard way to do this? Is there a setting of any kind that I can use? For example I want all of the datetime fields to be formated for short date, like {0:d}, I want decimal fields to have 4 decimal places, etc.
View 2 RepliesI really don't know if this Post fit in this Forum section. But here I go. I need some sugestion to develop an ASP.NET code that generate complex IDs / Keys automatically. Let me be more understandable:
I want to create uniquelly IDs with more complex composition (kind of 18958351512783997769711... or crlu0xakecjzlgmjsgnedr55) or something link that (doesn't matter the lenght... those are only examples).
So, I can use that to set COOKIE ID's... PRODUCTS CODE ID's.... CUSTOMER's CART ID's... etc... But it need to generate uniquelly numbers. I don't know if you got my point I hope you did.
Is there anyway to auto-generate ASP.NET controls based on fields in a SQLDataSource? It is really easy to create a form in WinForms by dragging the fields onto the form. You can even determine which control will be used (like a dropdown). Is there anyway to do this in ASP.NET? I don't want a DetailsView since I need to have separate controls that are created.
View 1 RepliesMy solution has a web.config file and it works, no problem. However, when i make a change to a file in one of my projects and then build, it auto-generates a web.config file for that project. Then if I go to the file in my browser, it throws a windows authentication error. I then have to delete the web.config file and it works.Why is it auto-generating this web.config file?
View 3 Repliesi have three text boxes. one is for Rate , second one is for Quantity and third one is for Amount. when i am entering value in two text boxes. after press tab key multiplication of these two text boxes generated in third text box(Amount).
View 3 Replieshow to make visible false some of my auto generated columns in grid dynamically.
View 5 RepliesI've scouted around and found partial answers to my question. If I insert a row into an orcle 9i db, what is the syntax in both the insert statement and then the .net code to get the id value so I can use it elsewhere?
View 2 RepliesI wanna generate a sequential auto generated id in c# and store it in mssql database.
format is abc0009.. abc0010.. abc9999.... abc10000 abc10001 and goes on..
I have looking for a code generation tool, that could auto generate web services based on feeding a tool the stored procedure that I would like.
Is there something that could achieve this for me ?
We are creating ReST Web Services using ASP.NET and OpenRasta.
Is there any tool that can:
create WADL file or/and create human readable API documentation similar which decribed resources/HTTP
methods supported for each resource, etc ?