I have a page with a detailsview where I can add articles (Generated by visual studio). Now the table contains a field (Autor) wich must contain the username of the Autor from the article. But when I run my page now I have to give it in manually ( in a textbox). I've searching for a way to bind the Profile Username with the insert Sql Query, @Autor value.
I tought maybe I should insert the value of the Profile username in the textbox and put the textbox visibel on false.
hello... Probably a simple question but I have to ask...using visual basic 2005 express...
I have two tables one with last name and basic info, one with detailed info. Both set up with Primary key and Foreign key.
I have a combo box that displays the last names and then by clicking the last name, text boxes fill with the "other" data from table1, however, there are some text boxes that I would like to fill with data from the table2. Any pointers??
I’m trying to teach myself C# and trying to create a simple (so I thought) little database using Infragistic's UltraWebGrid (Althought my question is more ASPish). Every sample I run across seems to only show the very basics and doesn’t seem to go into anything more than just a simple table and displaying it in a Gird. Which is pretty easy and I can do that all day and night. Anyway, my database has three tables in a one-to-many relationship. The database is of Trucking companies and which states they service and they can service multiple states. The database is like this: Compnies: TruckerID, Company Name, Address, etc. ServiceStates: TruckerID, StateID StateNames: StateID, StateName, StateAbbreviation I would like to show the States that they service in a Hierarchical Grid. I can write the SQL to do what I want to, basically do an inner join on ServicesStates and StateNames based on the TruckerID. I can sit all day and night getting what I would like to display in the WebGrid in the query builder on the SQL server. I figured it wouldn’t be much of a stretch to be able to do that in UltraWebGrid (Or whatever floats your boat). Anyway, on to my question. :) While browsing the samples on everything, I've figured out, that I will need to use the SqlDataAdapter Class, to access the database. Then I'll need to use the SQLConnection Class, and populate a DataSet. Now while in VS I can go to WebSite -> Add New Item -> DataSet slap my tables on there and away I go (at least it seems that way). If I do that, what exactly is the difference between doing that and using the dataset class? When I do that, is that not creating the dataset? I see all the classes it created (I named mine Trucking). I see all the SQL statements in the classes. I imagine I must be missing something *REALLY* simple or this just went way over my head at by at least 40,000 ft. Thanks, marly
Hai,i'm new asp.net and vb.net i have few textboxes and few dropdownlists.i want to insert data in (.mdf )database with these textboxes and dropdown lists please anybody can tell me a sample and simple example.
Hi, I have a page created within VS 2005 which uses a detailsView with a SQLDataSource which has insert, edit and delete items allowed with it. The problem is that if I delete a record I dont want to refresh the page as I want to set a label value to say item deleted. The problem then though is to select the item to delete I have a drop down which populates the details view on index change, but if I delete the item I cannot do a databind when its complete because it just binds to the existing dataset and does not do a fresh call on the database.Is there a command I can run to refresh the dataset on click of the delete button?Thanks
Hi,i have a question, i have a VS2005 and a SQL server 2000 enterprise in my office that i used for web developement,iam new to this, i made a data driven site using some automated controls available in the toolbox, but i need to made some manual process, like i need to make a LABEL show the SUM of specific number fields from my data base, they say i have to make a OLEDB connection using VB, but i don't know how,can you tell me how?Thanks
Hey all, I had a few questions about how to properly use the sqldatasource - I have a form with a single dropdownlist, databound to an sqldatasource that just has a select statement. Over the course of time, the client has requested additional dropdownlists, all of which point to different sqldatasources. After I reached 4 or 5, I noticed the page started to load incredibly slower. I played around with the caching features, and after a good while of reading up on it, finally was able to cache the page /data and notice an increase. Later, another 4 dropdownlists were added, 3 of which all take the same data. I assumed if I had 3 dropdownlists, which need the same data, I should use the same sqldatasource. What do you think? My page is behaving unaccepteably slow again. As a test, I created a new page, and bound it in the same fashion. I slowly added more dropdownlists /sqldatasources, and found it lags a bit on the initial load time (maybe 10-12 seconds of processing time before the page loads). The tables it is pulling data from do not have a primary key, and i'm doing select statements that return roughly 100-200 rows of data (per dropdownlist on average). I'm only selecting 1 column name (no select * here) I'm just curious if anyone has experienced similar issues, and also if there is anything I should do as a best practice while working with the sqldatasource. I've used hundreds of these on forms, and never experienced a problem. I only started noticing this on pages that have multiple. Also, when using multiple dropdowns that need the same data (I know that sounds goofy - why have 3 dropdownlists with the same data) should I use 3 individual datasources? Thanks for your help in advance, Mike
We are tired of null values coming out of from the database and we are directly coding behind UI decleratively. We set up a null value coding standarts but I wonder what are the disadvantages to our approach DataType The default value we send ALLOW NULL int,bit,decimal 0 NOnvarchar(string) " "(one space) NOdatetime YESbinary YES *in datetime we do not allow nulls in places such as _CREATEDATE and _LASTMODIFYDATE fields. What are other approaches for null besides writing your own layer to handle it ?
Hello, I would like to databind a textbox (the Text property) and I have try the following syntax: Text='<%# Bind("au_fname") %>' but there's no Datasource property for this control. I have defined a SqlDatasource object but can I link it to my Textbox. I have looked at the properties of the control: there's a Expressions section in which I can configure a connection string but thar's all. When I run the page I have no error but the textbox field is empty. Thanks for your help.
Does anybody know a good way to get a (near) live view of a sqlce database that doesn't involve ResultSets? I tried to use a resultset with the Sensitive option set, but it doesn't like the joins that I have to do in order to have the data make sense to the user.
If I add a new row and try to move there using the code below, nothing happens (neither movement to a new position nor error message), unless I remove the radio button bindings. (The same thing occurs if I attempt to move to any record that has a null value in the database field for a radio button).
myLastRow = dsData.Tables["Results"].NewRow();
dsData.Tables["Results"].Rows.Add(myLastRow);
I attempt to move by changing the value of the position property of the BindingContext object.
How can I retain the radio button bindings and still be able to add and move to a new row?
Here's a new one I came across that stumped me for a bit. DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'xxxx'. It appears that one of my dropdown menus was referencing the old SqlDataSource1for its data source id. I had already changed the name of the of the id to something else though. To fix it, I just updated the reference to the new name.
I m trying to UPDATE database using FormView and SqlDataSource and here is my code: <asp:SqlDataSource ID="sqlDS1" runat="server" ConnectionString="<%$ ConnectionStrings:myDB %>"UpdateCommand="UPDATE [Consultants] SET [firstName]=@FIRSTNAME,[lastName]=@LASTNAME,[skillCategoryID]=@SKILLCATID,[resourceManagerID]=@RMID,[AMgroupID]=@AMGROUPID,[SkillSet]=@SKILLSET,[statusID]=@STATUSID,[location]=@LOCATION,[comments]=@COMMENTS,[profile]=@PROFILE,[isAvailable]=@ISAVAILABLE,[dateModified]=getdate(),[focusID]=1 WHERE ([id]=@ID)"> <UpdateParameters> <asp:FormParameter FormField="txtFName" Name="FIRSTNAME" /> <asp:FormParameter FormField="txtLName" Name="LASTNAME" /> <asp:FormParameter FormField="ddlSkillCat" Name="SKILLCATID" /> <asp:FormParameter FormField="ddlRM" Name="RMID" /> <asp:FormParameter FormField="ddlAMGroup" Name="AMGROUPID" /> <asp:FormParameter FormField="txtSkillset" Name="SKILLSET" /> <asp:FormParameter FormField="ddlStatus" Name="STATUSID" Type="Int16" /> <asp:FormParameter FormField="txtLocation" Name="LOCATION" /> <asp:FormParameter FormField="txtComments" Name="COMMENTS"/> <asp:FormParameter FormField="txtProfile" Name="PROFILE" /> <asp:FormParameter FormField="cbAvailable" Name="ISAVAILABLE" /> <asp:QueryStringParameter Type="Int32" Name="ID" QueryStringField="id" /> </UpdateParameters>
</asp:SqlDataSource> //******************************************************************* <asp:FormView DefaultMode="Edit" ID="FormView1" runat="server" DataSourceID="sqlDS1" DataKeyNames="id"> <EditItemTemplate> <tr> <td class="blacktextbold"> Resource Manager: </td> <td class="blacktext"> <asp:DropDownList ID="ddlRM" CssClass="blacktext" runat="server" DataSource="<%#GetRM()%>" DataTextField="RMName" DataValueField="userID" SelectedValue="<%#Bind('RMID')%>" AppendDataBoundItems="true"> <asp:ListItem Value="-1">--Select RM--</asp:ListItem> </asp:DropDownList> <asp:CustomValidator ID="cvRM" runat="server" ValidationGroup="gpInsert" ControlToValidate="ddlRM" ClientValidationFunction="validateDropdown" OnServerValidate="servervalidateDropdown" Display="Dynamic" ErrorMessage="Required Field" CssClass="redtextsmallbold" /> </td> </tr> //******************************************************** here is my GetRM() function: protected DataSet GetRM() { string strConnection = ConfigurationManager.ConnectionStrings["myDB"].ToString(); SqlConnection objConnection = new SqlConnection(strConnection); String sqlSkillCats = "SELECT Roles.roleID, Roles.roleName, UsersInRoles.userID, UsersInRoles.roleID AS Expr1, Users.firstName + ' ' + Users.lastName AS RMName, Users.id AS Expr2" + " FROM Users INNER JOIN" + " UsersInRoles ON Users.id = UsersInRoles.userID CROSS JOIN" + " Roles" + " WHERE (Roles.roleName = 'accountmanager') AND (UsersInRoles.roleID = Roles.roleID) ORDER BY Users.firstName"; SqlDataAdapter objAdapter = new SqlDataAdapter(sqlSkillCats, objConnection); objConnection.Open(); //ddlDataSet = new DataSet(); try { objAdapter.Fill(dsConsultantRM, "ConsultantRM"); } catch (Exception ex) { Response.Write(ex.Message); } objConnection.Close(); return dsConsultantRM; }//****************************************************************** i get this error when i load the page:DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'RMID'. basically i m trying to UPDATE database using the value selected in the DropDownList, can anyone tell me whats wrong here...PLZ HELP!
HAI guys,i am suneel.i have a problem..please help me..i am binding my datalist.i have set my dtakey field to the primary key of teh database.i am not displaying the primary key(file_id).but i am displaying the other fields in that table.i have set databinder.Eval(container,dataitem."file_name").i have put one delete button in the item template...if i want to build now...i am getting an error.....DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'file_ID'.wat i have to do..please get me the reply..
Hi,Seems like a lot of people are having a similiar problem that I am having right now, but I am not able to find the solution to it. On the Page_load event, the gridview does display the data from database. When I click a button to insert the same data but different Waste_Profile_Num value, it gives me the databinding error. Component_Profile_ID is declared as an Identity and it is the primary key to the table. Anyway help???Ok, the following are code that I have: 1 <asp:SqlDataSource ID="sqlDSMaterialComposition" runat="server" ConnectionString="<%$ ConnectionStrings:HAZConnectionString %>" 2 SelectCommand="SELECT dbo.Component_Profile.Component_Profile_ID AS Component_Profile_ID, dbo.Component.Component, dbo.Component_Profile.Concentration, dbo.Component_Profile.Range, dbo.Component_Profile.Waste_Profile_Num, dbo.Component.Component_ID FROM dbo.Component INNER JOIN dbo.Component_Profile ON dbo.Component.Component_ID = dbo.Component_Profile.Component_ID WHERE (dbo.Component_Profile.Waste_Profile_Num = @Waste_Profile_Num)"> 3 <SelectParameters> 4 <asp:SessionParameter Name="Waste_Profile_Num" SessionField="Waste_Profile_Num" Type="Int32" /> 5 </SelectParameters> 6 </asp:SqlDataSource> 7 8 9 <asp:GridView ID="GridViewMaterialComposition" 10 runat="server" 11 DataKeyNames="Component_Profile_ID,Component_ID" 12 AutoGenerateColumns="False" ShowFooter="true"> 13 <Columns> 14 <asp:BoundField DataField="Component" HeaderText="Component" SortExpression="Component" FooterText="Total"/> 15 <asp:TemplateField HeaderText="Concentration" FooterStyle-Font-Bold="true"> 16 <ItemTemplate> 17 <%# SumConcentration(decimal.Parse(Eval("Concentration").ToString())).tostring("N2") %> 18 </ItemTemplate> 19 <FooterTemplate> 20 <%# GetConcentration().tostring("N2") %> 21 </FooterTemplate> 22 </asp:TemplateField> 23 <asp:BoundField DataField="Range" HeaderText="Range" SortExpression="Range" /> 24 <asp:BoundField DataField="Component_Profile_ID" HeaderText="Component_Profile_ID" ReadOnly="True" SortExpression="Component_Profile_ID" Visible="true" /> 25 <asp:BoundField DataField="Component_ID" HeaderText="Component_ID" ReadOnly="True" SortExpression="Component_ID" Visible="true"/> 26 <asp:BoundField DataField="Waste_Profile_Num" HeaderText="Waste_Profile_Num" ReadOnly="true" SortExpression="Waste_Profile_Num" Visible="true" /> 27 <asp:CommandField ShowEditButton="true" /> 28 <asp:TemplateField Visible="false"> 29 <ItemTemplate> 30 <asp:Label ID="lblComponentProfileID" runat="Server" Text='<% # Eval("Component_Profile_ID") %>'></asp:Label> 31 <asp:Label ID="lblComponentID" runat="Server" Text='<% # Eval("Component_ID") %>'></asp:Label> 32 </ItemTemplate> 33 </asp:TemplateField> 34 </Columns> 35 </asp:GridView>The following are the code-behind: 1 sqlSelect = "SELECT Range, Concentration, Component_ID FROM Component_Profile WHERE (Component_Profile.Waste_Profile_Num = " & previousWasteProfileNum & ")" 2 sqlDSMaterialComposition.SelectCommand = sqlSelect 3 Try 4 Dim dvComposition As Data.DataView = CType(sqlDSMaterialComposition.Select(DataSourceSelectArguments.Empty), Data.DataView) 5 For Each dr As Data.DataRow In dvComposition.Table.Rows 6 insertSql = "INSERT INTO Component_Profile ([Range], [Concentration], [Component_ID], [Waste_Profile_Num]) " 7 insertSql &= "VALUES (" & dr("Range").ToString.Trim & ", " & dr("Concentration").ToString.Trim & ", " & dr("Component_ID").ToString.Trim & ", " & CInt(Session("Waste_Profile_Num").ToString()) & ")" 8 sqlDSMaterialComposition.InsertCommand = insertSql 9 sqlDSMaterialComposition.Insert() 10 Next 11 Catch ex As Exception 12 13 End Try
I am actually a newbie to asp.net and i m using ASP.net 3.5 i.e, VWD 2008. i am using it for the first time as my tool to develop a website for my final year project. i am planning to develop an online job recruitment site like www.monster.com. Rigth now i am confused how will i manage my database. i've learned to use databinding concept of SQL SERVER in VWD 2008 but will it be enough to handle such huge # of Job postings and employers and as well as Resumes in pdf of word format? or do i have to create a separate databse in SQL Server and to connect it with my website? i am confused at the moment. please help me in this matter. Regards, Jigzy
Can I roll back certain query(insert/update) execution in one page if query (insert/update) in other page execution fails in asp.net.( I am using sqlserver 2000 as back end) scenario In a webpage1, I have insert query into master table and Page2 I have insert query to store data in sub table. I need to rollback the insert command execution for sub table ,if insert command to master table in web page1 is failed. (Query in webpage2 executes first, then only the query in webpage1) Can I use System. Transaction to solve this? Thanks in advance
i want to implement something like let say i have 2 table...customer table and order table....order table has a foreign key of customer table (maybe the customer_id)...is there any way that let say, i want to insert a particular customer_id in the customer table. Then, it will insert the particular customer_id in the order table also. I want to make one statement query that can solve that situation?
my application will add and delete and update records in db my problem is when to insert I have one text box and one dropdownbox one to write the name of db and the dropdownbox to choose the holding server ..
this is the structure of each table >> servers_tbl : SRV_ID,Server_Name DB_tbl : DB_ID,DB_Name srvdb_tbl : DB_ID,SRV_ID(forign keys from the previous tables) so >>> I want to add a new db to a server so I am writing the new db name in the textbox and choose the server from the dropdownbox and press a button to add the db name in the DB_tbl.DB_Name and add the db id in the DB_tbl.DB_ID to the srvdb_tbl.DB_ID and server id in the Servers_tbl.SRV_ID any one can help me ....
Hi All! I really need to pick your brains for a moment. I am attempting to create a INSERT INTO query that will select recrods from another existing table. This part can figure out... INSERT INTO "table1" ("column1", "column2")SELECT "column1", "column2"FROM "table2" Easy enough, but my table1 contains additional fields that the select statement does not retrieve from table2 (lets say "column3" and "column4"). I want to statically assign values to column3 and 4 at the same time. "column3" = Yes "column4" = No is there a way to do this within the same insert statement? Thanks for all your help!
can somebody help me in this plz m new to .net...m using visual studio 2005 how do we write this query actually...Dim con As SqlConnection = New SqlConnection("Server=;uid=;pwd=;Database=") Dim ra As Integer con.Open() myCommand = New SqlCommand("Insert into Telecheck(DateCheck,Hospital,Ward,PhoneNumber,StaffName,StatusOfStaff,StatusOfPhone)values(getdate(),'" & ComboBox1.SelectedItem.text & "','" & ComboBox3.SelectedItem.text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & ComboBox4.SelectedItem.text & "','" & ComboBox2.SelectedItem.text & "') ", con) ra = myCommand.ExecuteNonQuery() MessageBox.Show("Record entered") con.Close() the above is the code for windows here i am getting an error which says "{"Public member 'text' on type 'String' not found."}"the type of database is sqlserver 2000 and the type of column are nvarchar,only date is datetime
Declare @UID intDeclare @FID varchar(50)set @UID = 1set @FID = '1,2,3'insert into table_name (UID,FID) values(@UID,'+@FID+') Can we have an insert query like above or is their another way to get the result like below the result should beUID FID 1 1 1 2 1 3
I am needing to insert two values from tables, one would be from a query, which is easy, one needs to be static, easy. The not easiness (not a word) comes from combining the two. Here would be an example of what I am trying to run...
Code:
insert into MEMBER_SUBSCRIPTION_CHANNEL_FORMAT (MEMBER_ID,SUBSCRIPTION_CHANNEL_FORMAT_ID) (select m.MEMBER_ID from MEMBER m,MEMBER_SUBSCRIPTION ms where m.MEMBER_ID = ms.MEMBER_ID and m.SUBSCRIPTION_FORMAT_ID = 1 and ms.SUBSCRIPTION_ID = 1), 1
the last part of the code ', 1' would be the static part. Any ideas?
Hi guys I need to insert some updated Terms from another table but it keeps telling me that it cant because it would be creating duplicates. The funny thing about it is I did a comparison with the two tables one table is called UpdateForTerms Table and the other is called TERMINATION
SELECT UpdateForTerms.EMPLOYEE, UpdateForTerms.EMP_STATUS, UpdateForTerms.TERM_DATE, UpdateForTerms.DEPARTMENT, UpdateForTerms.LAST_NAME, UpdateForTerms.FIRST_NAME, UpdateForTerms.DESCRIPTION FROM UpdateForTerms LEFT JOIN TERMINATION ON UpdateForTerms.EMPLOYEE = TERMINATION.[TM #] WHERE (((TERMINATION.[TM #]) Is Null));
I made the results of this into a query so I could update the Termination table. The reason I created this query is so that I could weed out those records the Terminations table already had. Kind of a futile attempt it seems
I've been going around in circles and was wondering if anyone could help with this insert query. (I'm using SQL Server 2005).
I have two tables aspnet_Users and aspnet_Draws. They have a 1 to many relationship, with UserID being the PK in aspnet_Users and the FK in aspnet_Draws. Table structure is:
aspnet_Draws ID (PK) UserId DrawDate NumberOfEntries
aspnet_Users UserId (PK) UserName
I want to insert a row into aspnet_Draws. UserID needs to be taken from aspnet_Users where UserName is a particular value, e.g. NameXXX
DrawDate and NumberOfEntries do not allow nulls and also need to be updated, though these values will be taken from a webForm and not from aspnet_Users. ID is automatically incremented.
Basically, what is the best method, ie. not in, left join, etc to write this insert query? I feel like I know this, but mostly I want to make sure I am using the most efficient way. There are 1.1M records in the first table, named Complete_Products, and 979K in tblProducts. I already ran the update query that selected on the ProductCode column in both that updated tblProduct for the records that were also in Complete_Products. That ran fine, a bit long, but it worked and updated the 805,273 records they had in common. Now I need to insert the new records that are in Complete_Products that are not in tblProducts.
IF OBJECT_ID('dbo.InsITRRComments') IS NOT NULL BEGIN DROP PROCEDURE dbo.InsITRRComments IF OBJECT_ID('dbo.InsITRRComments') IS NOT NULL PRINT '<<< FAILED DROPPING PROCEDURE dbo.InsITRRComments >>' ELSE PRINT '<<< DROPPED PROCEDURE dbo.InsITRRComments >>' END go SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO
INSERT INTO ITRRComments VALUES ( @DacType, @DacTypeId, @TypeOfComment, @Comments, @RiskId_External_ID, @UserId, (select FullUserName from SecurityUsers where UserId=@UserId) @AmendedDateTime, 'N' ) END
GO
IF OBJECT_ID('dbo.InsITRRComments') IS NOT NULL PRINT '<<< CREATED PROCEDURE dbo.InsITRRComments>>>' ELSE PRINT '<<< FAILED CREATING PROCEDURE dbo.InsITRRComments>>>' go
GRANT EXECUTE ON dbo.InsITRRComments TO AppWrite go
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
Subqueries are not allowed in this context. Only scalar expressions are allowed
This is the error that I'm getting, how do I get round the issue of a sub query problem
How do I use Enterprise manager to insert records from one table into a blank table ? I open my table (with data) as a query and change it to an Insert From query but it doesn't seem to build the query correctly.
