is it possible to insert some table i have in another database in the wss_content?
i need to link the userinfo table to some table in my database. and i cant create a foreignkey between these 2 tables.
View Complete Post
I want to use gridview and bind the data and after i want insert the data in database using jquery,
below the link i got for delete
but i want the sample example for insert row from gridivew and add the database.
is it possible to create a custom list in sharepoint designer to enter a vacation request and using a work flow that goes to the HR department. but when the HR department approve the request the HR can store these requested data into another database?
what i mean is, the employee fill a form in to request some vacation days using a custom list in my wss3 site. i assume that these data will be stored in the WSS_content database. now when the HR department get this filled form they have to store the data
of the form in to a database but not in the WSS_Content database.
is this possible?
I have 2 tables in SqlServer 2008.
Table1: T1id, SomeData
Table2: T2id, T1id, SomeData
I am using DataAdapter.FillSchema to create shema of tables in DataSet. I created DataRelation on columns T1id in both tables.
Now when i try to Update Sql Database T1id in Table2 remains 0 and not the value of T1id in Table1.
I can successfully update Sql Database if i fill DataSet with records first (Using DataAdapter.Fill), but that's not what i want to do. I don't need "old" records in my dataset. I want to use dataset just to store all imputs from user until the proccess is done and then insert all those records "at the same time".
I think i'm getting it wrong with ForeignKeyConstraints, maybe UpdateRule is not set to cascade, i just don't know.
I have been trying to work this out for 6 days now and i'm about to break something on half.
Can someone please guide me to right direction, maybe post some sample, anything.... please!
My old post regarding this:
How to update Sql Server related tables from Dataset(SchemaFill)
SqlDataAdapter.Update related tables
Please help me to insert data to database from a content page of a master page. My code is working fine when i use my code without master page but with content page of master page i dnt knw what goes wrong. Help me on this please.
I have spent 2 days reading and trying to figure this out and everything i have read and every book I have brought only tells how to read info from a database and how to edit info that is in a database and they all display the data in the database!
I have a page created (getinfo.aspx)
On that page I have a correctly configured SQLDatasource (SQLSource1) (it is set to allow insert, edit and delete).
I have 1 fileupload control uploadUserPhoto
I have 2 text boxes txtName txtPhone txtCity
I have 2 drop down list boxes dropState dropCountry
The 2 drop down list boxes are "binded" to to seperate tables (via 2 other correctly configured SQLDatasource controls 0 but with out permission to insert, edit or delete) and they correctly provide a drop down list for the user to pick from the 51 states and the 200+ Countries. Those work wonderfully).
I also have a Button Control btnSubmitInfo
The table (myFriends) that SQLSource1 is "connected to" has the following columns:Column Name Type Length Nullable userID uniqueidentifier 16 false userName sql_variant 80
Please help me, I have been trying this for a week now and this is how far I have gotten.
I am new to this, and I am using MS Visual Web Developer Express.
OK - This is what I have come up with, but when I run it I get the following error (I decided to just try to use a simplified table just to get an understanding of the basic concepts):
Partial Class label_form Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click ' Declaring variables Dim username, labelname, ownersname, address1, address2, city, state, zipcode, country, contactnumber, emailaddress, data_source, con, sql_insert
' Check if Necessary Text Is Missing ( will do this once I can get it to work with no empty text boxes)
' Get Values from TextBoxes username = txtUserName.Text labelname = txtLabelName.Text ownersname = txtOwnersName
I am trying to insert data into my table whose primary key is auto increment. The problem i encounter is that anytime i perform the insert, it goes through and i can view
it when my application is running but as soon as i stop debugging and i run again i dont see the data again. I also notice that the insertion i did does not show up in the database. Below is the code i am using:
String name, type; name = txtname.Text; type = txttype.Text; int qtyToInt = Int32.Parse(txtqty.Text); decimal priceToInt = decimal.Parse(txtprice.Text); shopDataSet.stockRow newStockRow = shopDataSet1.stock.NewstockRow(); newStockRow.name = name; newStockRow.type = type; newStockRow.quantity = qtyToInt; newStockRow.price = priceToInt; this.shopDataSet1.stock.Rows.Add(newStockRow); this.stockTableAdapter1.Update(this.shopDataSet1.stock);