DataBinding RadioButtons Group
Feb 19, 2008
Hello Everyone!
I am getting started with DataBinding with SSE 2005 and VC#
The problem i am facing is that i need to bind a group of radio buttons eg: Duration Type: Days, Weeks, Months, Years.
The field type in the database is tinyint and the values are 1,2,3,4 for Days, Weeks, Months and Years respectively.
How can i bind a group of radio buttons to the tinyint data in table?
Any help/hint is appericiated.
Thankyou for taking the time to read this.
View 1 Replies
ADVERTISEMENT
Oct 17, 2007
Hi all,
I am having issue with a set of radiobuttons. I have four radiobuttons associated by a groupname (answer). I am attempting to store the text of the selected radiobutton when the user make a selection and clicks submit. For reasons unknown... each of the radiobutton.checked values are remaining false hence I cannot interrogate for a checked equal true to insert associated text of check response.
Here is how I am interrogating who is checked:
If rb1.Checked = True Then
useranswer = rb1.Text.ToString
ElseIf rb2.Checked = True Then
useranswer = rb2.Text.ToString
ElseIf rb3.Checked = True Then
useranswer = rb3.Text.ToString
ElseIf rb4.Checked = True Then
useranswer = rb4.Text.ToString
End If
I then attempt to insert this text to sql but none of the rb values are true hence a null wont insert.
Cmd1.Parameters.Add(New SqlParameter("@answer", useranswer))
How can I evaluate grouped radiobutton checked values?
Many thanks in advance...
Scott
View 2 Replies
View Related
Oct 25, 2006
Hi,
I have a little question. I have an application which interfaces with a SQL Express Database. On a form, I want to bind a control which is made of several Radio buttons to a table column which is in fact a varchar(1). This is the picture:
Table column: OptVisualRpt varchar(1)
Screen control: 2 radio buttons
rb_VisRPTbImp_O for "yes"
rb_VisRPTbImp_N for "no"
I'm really scratching my head as how I can bind a single table column to my radio buttons controls. I think that I just can't this way but rather have to use an intermediate variable or control.
Solution 1?
I thought of using a local variable that I would set to "y" or "n" following "CheckedChanged" events fired from radio buttons but I don't know how to bind this variable to my table column.
Solution 2?
I thought of placing a hidden text control into my form, which one would be binded to my table column, that I would also set to "y" or "n" following "CheckedChanged" events fired from radio buttons.
Any of these solutions which would be feasible or any more neat way to do it?
Many thanks in advance,
Stéphane
View 1 Replies
View Related
Sep 17, 2007
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??
View 1 Replies
View Related
Mar 25, 2008
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
View 14 Replies
View Related
Jun 19, 2008
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.
Thanking you
View 3 Replies
View Related
Mar 11, 2007
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
View 3 Replies
View Related
Mar 4, 2008
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
View 13 Replies
View Related
Nov 9, 2006
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
View 3 Replies
View Related
Apr 18, 2007
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 ?
View 3 Replies
View Related
May 28, 2006
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.
View 1 Replies
View Related
Sep 18, 2007
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.
Thanks
View 1 Replies
View Related
Apr 27, 2006
I have a windows form containing some text boxes and radio buttons bount to an SQL Server database, with code like the following:
this.tbBorrowerLastName.DataBindings.Add (new Binding("Text", dsData.Tables["Results"],"BorrowerLastName"();
this.rbMale.DataBindings.Add(new Binding("Checked", dsData.Tables["Results"],"Male"))
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?
Any help would be appreciated.
View 1 Replies
View Related
Jan 22, 2007
Hello,
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.
But When i saw the component code I saw that Text= is already bound, so it's not possible to insert a value<asp:TextBox ID="auteurTextBox" Visible="true" runat="server" Text='<%# Bind("auteur") %>'> Here is whole the page code (line 23 is the textbox). 1 <asp:FormView ID="FormView1" runat="server" DataKeyNames="id" DataSourceID="SqlDataSource1" AllowPaging="True" CellPadding="4" ForeColor="#333333" style="left: 30%; position: relative">
2 <EditItemTemplate>
3 <asp:Label ID="idLabel1" Visible="false" runat="server" Text='<%# Eval("id") %>'></asp:Label>
4 <asp:TextBox ID="auteurTextBox" Visible="false" runat="server" Text='<%# Bind("auteur") %>'>
5 </asp:TextBox>
6 soort:
7 <asp:TextBox ID="soortTextBox" runat="server" Text='<%# Bind("soort") %>'>
8 </asp:TextBox><br />
9 titel:
10 <asp:TextBox ID="titelTextBox" runat="server" Text='<%# Bind("titel") %>'>
11 </asp:TextBox><br />
12 text:
13 <asp:TextBox ID="textTextBox" Height="200px" TextMode="MultiLine" Rows="20" Width="260px" runat="server" Text='<%# Bind("text") %>'>
14 </asp:TextBox><br />
15 <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
16 Text="Update">
17 </asp:LinkButton>
18 <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
19 Text="Cancel">
20 </asp:LinkButton>
21 </EditItemTemplate>
22 <InsertItemTemplate>
23 <asp:TextBox ID="auteurTextBox" Visible="true" runat="server" Text='<%# Bind("auteur") %>'>
24 </asp:TextBox><br />
25 Soort:
26 <asp:TextBox ID="soortTextBox" runat="server" Text='<%# Bind("soort") %>'>
27 </asp:TextBox><br />
28 titel:
29 <asp:TextBox ID="titelTextBox" runat="server" Text='<%# Bind("titel") %>'>
30 </asp:TextBox><br />
31 text:
32 <asp:TextBox ID="textTextBox" runat="server" Text='<%# Bind("text") %>'>
33 </asp:TextBox><br />
34 <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
35 Text="Insert">
36 </asp:LinkButton>
37 <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
38 Text="Cancel">
39 </asp:LinkButton>
40 </InsertItemTemplate>
41 <ItemTemplate>
42 <asp:Label ID="idLabel" Visible="false" runat="server" Text='<%# Eval("id") %>'></asp:Label><br />
43 <asp:Label ID="auteurLabel" Visible="false" runat="server" Text='<%# Bind("auteur") %>'></asp:Label><br />
44 soort:
45 <asp:Label ID="soortLabel" runat="server" Text='<%# Bind("soort") %>'></asp:Label><br />
46 titel:
47 <asp:Label ID="titelLabel" runat="server" Text='<%# Bind("titel") %>'></asp:Label><br />
48 text:
49 <asp:Label ID="textLabel" runat="server" Text='<%# Bind("text") %>'></asp:Label><br />
50 <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
51 Text="Edit">
52 </asp:LinkButton>
53 <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
54 Text="Delete">
55 </asp:LinkButton>
56 <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
57 Text="New">
58 </asp:LinkButton>
59 </ItemTemplate>
60 <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
61 <EditRowStyle BackColor="#2461BF" />
62 <RowStyle BackColor="#EFF3FB" />
63 <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
64 <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
65 </asp:FormView>
66 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
67 ConnectionString="<%$ ConnectionStrings<img src="images/smilies/biggrinn.gif" border="0" alt="">atabankConnectie %>" DeleteCommand="DELETE FROM [artikel2] WHERE [id] = @original_id AND [auteur] = @original_auteur AND [soort] = @original_soort AND [titel] = @original_titel AND [text] = @original_text"
68 InsertCommand="INSERT INTO [artikel2] ([auteur], [soort], [titel], [text]) VALUES (@auteur, @soort, @titel, @text)"
69 OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [artikel2] WHERE [auteur] = @auteur"
70 UpdateCommand="UPDATE [artikel2] SET [auteur] = @auteur, [soort] = @soort, [titel] = @titel, [text] = @text WHERE [id] = @original_id AND [auteur] = @original_auteur AND [soort] = @original_soort AND [titel] = @original_titel AND [text] = @original_text">
71 <DeleteParameters>
72 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_id" Type="Int32">
73 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_auteur" Type="String">
74 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_soort" Type="String">
75 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_titel" Type="String">
76 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_text" Type="String">
77 </DeleteParameters>
78 <UpdateParameters>
79 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="auteur" Type="String">
80 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="soort" Type="String">
81 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="titel" Type="String">
82 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="text" Type="String">
83 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_id" Type="Int32">
84 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_auteur" Type="String">
85 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_soort" Type="String">
86 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_titel" Type="String">
87 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="original_text" Type="String">
88 </UpdateParameters>
89 <InsertParameters>
90 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="auteur" Type="String">
91 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="soort" Type="String">
92 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="titel" Type="String">
93 <asp src="images/smilies/tongue.gif" border="0" alt="">arameter Name="text" Type="String">
94 </InsertParameters>
95 </asp:SqlDataSource>
96 </LoggedInTemplate>
97 </asp:LoginView>
98 </asp:Content>
99
Can somebody help me?
View 14 Replies
View Related
Feb 16, 2007
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.
Thought I'd share, just in case
View 2 Replies
View Related
Aug 11, 2006
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!
View 2 Replies
View Related
Sep 16, 2006
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..
View 2 Replies
View Related
Mar 22, 2007
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
View 1 Replies
View Related
Mar 13, 2008
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
View 6 Replies
View Related
Sep 29, 2015
I have an SSRS 2012 table report with groups; each group is broken ie. one group for one page, and there are multiple groups in multiple pages.
'GroupName' column has multiple values - X,Y,Z,......
I need to group 'GroupName' with X,Y,Z,..... ie value X in page 1,value Y in page 2, value Z in page 3...
Now, I need to display another column (ABC) in this table report (outside the group column 'GroupName'); this outside column itself is another column header (not a group header) in the table (report) and it derives its name partly from the 'GroupName' values:
Example:
Value X for GroupName in page 1 will mean, in page 1, column Name of ABC column must be ABC-X Value Y for GroupName in page 2 will mean, in page 2, column Name of ABC column must be ABC-Y Value Z for GroupName in page 3 will mean, in page 3, column Name of
ABC column must be ABC-Z
ie the column name of ABC (Clm ABC) must be dynamic as per the GroupName values (X,Y,Z....)
Page1:
GroupName Clm ABC-X
X
Page2:
GroupName Clm ABC-Y
Y
Page3:
GroupName Clm ABC-Z
Z
I have been able to use First(ReportItems!GroupName.Value) in the Page Header to get GroupNames displayed in each page; I get X in page 1, Y in page 2, Z in page 3.....
However, when I use ReportItems (that refers to a group name) in the Report Body outside the group,
I get the following error:
Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope
I need to get the X, Y, Z ... in each page for the column ABC.
I have been able to use this - First(Fields!GroupName.Value); however, I get ABC-X, ABC-X, ABC-X in each of the pages for the ABC column, instead of ABC-X in page 1, ABC-Y in page 2, ABC-Z in page 3, ...
View 4 Replies
View Related
Nov 27, 2007
Hi!
I've posted a feedback with Microsoft to see if we can get them to fix the issue described below, but so far no one from Microsoft has commented to let us know what they're doing about this problem! I'm posting this here to see if maybe we can get more people to rate this feedback or chime in on what a pain it is! Please feel free to add your own comments or how you had to work around this issue and whether or not you think this is something Microsoft should be addressing NOW.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=311679
Provide Individual Page Numbering per Group and Total Pages per Group
Currently in a Reporting Services report, you can't readily reset the page number for each group in a table, nor can you display the total number of pages per group. For example, if I'm printing invoices and each invoice is a separate group, I'd like to be able to print "Page 1 of 5" , "Page 2 of 5" etc. for the first invoice, then "Page 1 of 3" when the next invoice begins, and so on. This was easy in Crystal Reports. I realize that Crystal Reports has a two-pass process that enables that kind of pagination. However, this is REALLY important functionality that's just missing from Reporting Services and I'm hoping you'll provide it REALLY SOON! Yeah, I know there are work-arounds if you can know exactly how many rows of information there are on each page. But gosh! That's not practical, especially if you have second level groups inside the main group or text blocks in rows that can 'grow' to more than one line. I've read a couple of work-arounds, but none of them works correctly and consistently when more than one user is running the same report or when you print the report while you're looking at it on the screen. I still may need access to the overall report page number and the overall total number of pages, so don't get rid of that. It's just that if you're doing this already for the entire report, I don't see why you can't do it per group! Lots of people have been asking for this for years, and I don't understand why it hasn't been implemented.
I've read a few articles on this topic, but no one has come up with a decent work around. My theory is that Microsoft should be addressing this immediately. This is major functionality that's just plain missing from SSRS and should have been there from the start. If anyone from Microsoft can let us know what's going on with this issue or if anyone would like for me to clarify this further, feel free to let me know.
Thanks!
Karen
View 1 Replies
View Related
Nov 6, 2015
I have an SSRS report with groups that when exported to excel contains drill-in's (plus marks on left side). The issue I have is that for all the groups in the drill-in, those cells become merged. I want to keep the group drill-in but have the cells UNMERGED. I have heard this can be done with the RDL XML but I don't know what to modify to accomplish this.
View 4 Replies
View Related
Jan 10, 2014
I'd like to ask how you would get the OUTPUT below from the TABLE below:
TABLE:
id category
1 A
2 C
3 A
4 A
5 B
6 C
7 B
OUTPUT:
category count id's
A 3 1,3,4
B 2 5,7
C 2 2,6
The code would go something like:
Select category, count(*), .... as id's
from TABLE
group by category
I just need to find that .... part.
View 3 Replies
View Related
Sep 25, 2003
I have a user in SQL Server with a NT login of Mike
I changed his NT account to Mikel in User Manager
Now when I try to add Mikel, Im getting error 15401.
Do I need to delete NT login in SQL Server 'Mike' account first ?..before adding 'Mikel' ?
Can I go into the Master database and just change Mike login to Mikel ?
Thank you
View 3 Replies
View Related
Feb 28, 2014
I'm having a fight with Reporting Services at the minute when trying to compute an average at the row group level for a value summed in a column group.I have the following column groups:
Year
Month
Date
And the following row groups:
Region
Product
SubType (hidden, data at the date level is summed to Product)
At the moment I'm computing the average for SubType for each Date at the Product level (giving a decimal value), so for each day I end up with a nice average, that works. However I am unable to average that average over the whole Year for a Product. The issue being that I'm trying to combine Row Groups (Product) and Column Groups (Date/Year)
View 0 Replies
View Related
May 1, 2014
select top 15 count(*) as cnt, state from table
group by state
order by cnt desc
[code[...
Can the above three queries be combined into one and still be fast, if so how?What i am trying to go is an item count, by group, similar to ones Inbox in Outlook.
View 9 Replies
View Related
Nov 21, 2007
I have a need to show a row inside a table group to simulate a header row for the data rows inside the group. The table will not have a real header or footer. Thanks for the help.
View 1 Replies
View Related
Jan 5, 2008
I have one domoain in the forest. The domain level is set to Windows 2000 native mode and forest level is set to mixed mode. My SQL server 2005 server joined to this domain. I added a brand new domain local group and add a normal user account to this domain local group. I login to the SQL server 2005 server and make a query "SELECT * FROM sys.login_token". I cannot see my domain local group in sys.login_token. However, if I add my account to a global group, I can see it there.
Then, I setup another forest. This time, I have domain level set to Windows 2003 mode and forest level is set to Windows 2003 native mode. I do the same testing. This time, I can see my domain local group in sys.login_token.
Why does SQL server 2005 has this limitation? Is it a bug?
View 1 Replies
View Related
Feb 6, 2008
HiI am new to SQL and am having a problem. I need to fix my query to do the following...2) get a total of the number of rows returned.
DECLARE @StartDate varchar(12)DECLARE @EndDate varchar(12)DECLARE @Region varchar(20)
SET @StartDate = '01/01/2002'SET @EndDate = '12/31/2008'SET @Region = 'Central'
SELECTA.createdon,A.casetypecodename,A.subjectidname,A.title,A.accountid,A.customerid,A.customeridname,B.new_Region,B.new_RegionName
FROM dbo.FilteredIncident AINNER JOIN dbo.FilteredAccount B ON A.customerid = B.accountid
WHERE (A.createdon >=@StartDate AND A.createdon <= @EndDate)AND (B.new_RegionName = @Region)AND (A.casetypecode = 2)
View 1 Replies
View Related
Jan 29, 2007
I'm new to MSSQL 2005 and want to get a summary of a log table. I want to count all the rows for each date based on a DATETIME field called 'post_date' that holds the date and time of each record's creation.
this is the best I can come up with:
Code:
SELECT
DISTINCT(LEFT(post_date,11)) AS post_date, COUNT(DISTINCT(LEFT(post_date,11))) AS total_posts
FROM log_directory_contacts
GROUP BY post_date
The results show each date but the count column ('total_posts') returns '1' for every row even when I know their are more than 1 record on that date.
What am I doing wrong? Thanks!
View 9 Replies
View Related
May 28, 2007
Hi folks,
I have a Projects , each project have many tasks now i want to display tasks replated to each project:
for example:
Project1-------------------->task1
task2
task3
task4
Project2----------------------->task4
task5
task6
.............................................projectN.....................
how to write query for this
i have 2 tables:
Project .......>columns are projectid
Task------------->columns are projectid, taskid
|
View 4 Replies
View Related
Jun 6, 2007
I have a matrix with two row groups and one column group with about 6 items in it. I have about 2100 rows at the lowewst row group level. This report was built solely for excel export. The first row group has about 20 items and controls the visibility of the other group. When I toggle the visibility of the second row group, how can I make the the header of the first row group copy down for each row of the other row group? The first row group is the Section and the second is Mnemonic.
Example:
Now:
Code Snippet
Column Column
Section1 -
Mnemonic
Mnemonic
Mnemonic
Mnemonic
Section2 -
Mnemonic
Mnemonic
Mnemonic
Mnemonic
Should be:
Code Snippet
Column Column
Section1 -
Section1 Mnemonic
Section1 Mnemonic
Section1 Mnemonic
Section2 -
Section2 Mnemonic
Section2 Mnemonic
Section2 Mnemonic
View 2 Replies
View Related
Feb 12, 2015
I have a code like this:
SELECT Node_ID,Day,Operation, AA,BB
FROM
(SELECT
CASE
WHEN Operation LIKE 'NOTIFY' THEN SUM(Total_request) ELSE 0 END AS AA,
CASE WHEN OPERATION LIKE 'SEARCH' THEN SUM(Total_requests) ELSE 0 END AS BB,Node_ID,DAY,Operation
[code]....
So i want to make two columns by the name of operation. in the real code AA and BB are calculates with many counters. My code doesn't work, I have an error: "not a single-group group function" .....
View 1 Replies
View Related
