i have a table in my database.i want to assign a unique id (primary) automatically when each data is submitted.how to set this one is sql server 2008? i tried but couldnt do it.
View 10 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
I believe this is a newbie question, but i just figure out my head around.. does anyone know how to auto adjust the control in the table cell so its width follows the width of table cell?
View 14 RepliesI have a table: TableOne
rowid (int, not null)
pid(nvarchar(1020), null)
gid(nvarchar(1020),null)
tid((nvarchar(1020),null)
I get value of pid, gid and tid from dropdown box. I would like to insert pid, gid, tid into TableOne. How to auto increase rowid when insert into this table?
auto increment alphanumeric primary key(eg :ABC001) in sql server 2005 database table.
View 2 RepliesI have a simple online web system where it possible for the visitors to "play around" with the system. They can like create categories and products and so forth. Everything they create are stored into a database.
What I want is to be able to reset this database with my default values (table data) every n hours.
So for example if we have a bunch of users that have played with the system and created new things. Then I want to be able to make some kode that deletes all data in the tables in this database and fill it with default data. The default data can come from a backup file, or another database with same tables structure or whatever.
I want this task to be done every day at 12 pm or every n hour.
Is this possible (by forexample scheduled webservice tasks or just something as long as it is simple).
I'm making a visitor management application and I made three tables namely tblStudent,tblEmployee and tblVolunteer in SQL.I made a table according to the categories of a visitor.Do I still need to make a tblVisitor that would be the "general" table for the three tables made?I'm really confused whether it's needed or not to make a table to join similar attributes of student,employee and volunteer.
View 2 RepliesI tried nested ListViews but can get the display wanted.In my database I have a Category Table and a Product table.They share the CG_ID value.I want to make a stored procedure that will use two select statements to produce a single table.that can be used as a ListView DataSource.
[code]...
i 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 RepliesI need to make an online automatic post tool using ASP.NET C# to post items (using post or get) to ASP (VB script) webstore sites, for example how to capture the post data and how to reproduce it using ASP.NET C#.
how to upload post and get variables also with cookies
I'm currently writing a web service using WCF in VB.NET.Previous web services I wrote used ASMX but I wanted to learn WCF and so far it's going well. I actually prefer the way WCF does things.One thing I miss however is the way that ASMX used to generate example SOAP requests and responses. It was like getting documentation for free.Is there anyway to auto generate SOAP documentation for WCF?
View 1 RepliesI am developing a movie database, in that i have autpcomplete with image feature for the users to search film titles. In that when the text box suggests the film titles with image if the user clicks the film title the title text is copied into the text box and if we click the search button then only it is redirecting to another page, my requirement is when the suggestion comes and if the user clicks a particular suggestion the page has to be redirected to another page and there i have written code to fetch details of the film from the database. I have used web service and the code is
<%@ WebHandler Language="C#" Class="Search_CS" %>
using System;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;
public class Search_CS : IHttpHandler {
[CODE] ...
I got a table PartsMedia where I can insert all the images related to a product. The table has the columns :
PartsMediaID , auto-increment
PartsNo
MediaLink
MediaDescription
CatalogCode
SortCode
I want to insert a complete row with automatic increment and the PartsNo should be the same as the PartsNo from the PartsMaster table.
The medialink should be the PartsNo + '-2.jpg'
The mediadescription is for example 'image2'
The CatalogCode should be 'catalog'
and the sorting code should be '0'
From The partsMaster table I Just need the PartNo So I can add this to the PartMedia Table. The PartNo is the foreign key in the PartMedia table.
The following I got so far but no luck
insert into dbo.PartsMedia (PartNo,MediaLink,MediaDescription,CatalogCode, SortCode)
values (dbo.PartsMaster.PartNo, PartsMaster.PartNo+'-2.jpg','image2', 'catalog','0')
I have create one SQL Database table. Columes are Longitude and Latitude.User manually enter Longitude and Latitude.then how to auto check every few days entire data will correct or not.If some data will wrong then auto update nearest Longitude and latitude
View 1 Repliesi have a question, suppose i have a table 'tblImage' which have 3 rows of data and my auto increment is not +1.
imageId imageName
1 a.gif
2 b.gif
4 c.gif
i want to query '2' using LINQ C# to the table in MS SQL and show the record which i have done easily BUT now i want to get the next auto incremented value to make Next button on the sane web form, which is in this case is '4' and i also want the previous imageId as well.
How to insert a auto increase in table of database? table TechCode consist TechCodeID and TechCodeDesc These following are my code
Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim strTechCode As String
strTechCode = tbAdd.Text
Dim sqlCon As New SqlConnection
sqlCon = db.getConnection()
If sqlCon.State = ConnectionState.Closed Then
sqlCon.Open()
End If
Using sqlCmd As SqlCommand = sqlCon.CreateCommand()
sqlCmd.CommandText = "InsertTechCode"
sqlCmd.CommandType = CommandType.StoredProcedure
'TechCodeID is the auto increase ID in database
sqlCmd.Parameters.AddWithValue("@TechCodeID", Decimal.Parse("TechCodeID"))
sqlCmd.Parameters.AddWithValue("@TechCodeDesc", strTechCode)
sqlCmd.ExecuteNonQuery()
If sqlCon.State = ConnectionState.Open Then
sqlCon.Close()
End If
End Using
End Sub
I am using VS 2010 and VS 2005.
I have a webform with 5 textbox fields on it. Form successfully store data in database table.
I want to add 6th col of "Date" in database table. And when save my webform data. Today's date automatically sotred with save data in database table.
How it could be done ?
I am having trouble with .rdlc field sizing. Regardless of the table/field size settings in my .rdlc report, the reportviewer always shrinks the fields and table. I have tested everything I can think of, and searched the web for a solution to this problem, but no luck yet.
I have also tried just about every size setting there is and even looked in the output html, but nothing seems to be decreasing the width. I have attached two images. in the first image, I have added a black border around my table, and a red border around one of the fields to demonstrate the auto-shrink issue. the second image shows my vs report settings.
ReportViewer settings:
[code]....
how to set the height of table row details become auto in report viewer? due to my data maximum length is 300, however some data may be short till 10 characters.how to make the height become auto and depends on the content of data?
View 1 RepliesI have an ID column (int) in my table which also needs to be a unique key.
last time I worked with a database (BD2), I set this as an autoIncrement feild and it would automaticaly 'deal with it' (ie, maintain the last used value somewhere and automaticaly used that value (after incrementing it) for any new row on the table).
How do I handle this in ASP.NET. Especially, as I try to add a new line based on form content when the user presses on a button (C#).
I have a gridview (Edit and Delete enabled) that shows a table. A Text Box and A Button. When I type something in the textbox and click the button, the button runs the datasource.filterexpression and filters out the rows. The question whenever I click on the edit button after the filter has been applied The grid auto resets back to the original table? How can I solve this?
View 1 RepliesI 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 a function that used a mySQL Data Adapter and inserts a new row.
I want the function to return the value of the auto-incremented column of the updated row.
Public Function addRow(ByVal colA as String, ByVal colB as String) As Integer
Dim dbConnection As New MySqlConnection("server=xxx; user id=xxx; password=xxx; database=xxx; pooling=false;")
Dim dbDataAdapter As New MySqlDataAdapter("SELECT * FROM table", dbConnection)
[Code].....
The "Return..." line doesn't work and don't know what the correct code would be.
I need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
my main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 Replies