I want to Add product with Solr.net Schema file. my database Table is
Category table - catid, catname
Brand table - brandid, brandname
Item table - productid, productname, productdesc
Filter table- key, value
Note:- if i add all with a Table then data Repeatation occur. so if u have better solution then please suggest me with an examle.
I want to use SOLR search platform from the Apache Lucene project in my ASP.NET web application.The basic purpose is to utilise SOLR for search from database for my entity related property.Let me be specific.I have three tables in Database and all of them have 7-10 collumn with thousands of dataE.g Table #1 TBLEmployee (Containes refernce from TBLEmployeMentType,TBLEmployeeDept) and Table #2 EmploymentType and Table #3 is TBLEmployeeDept.In short two tables are reffered in one table. And all of them are having too many data.
View 1 Repliesi Want to show data for single employee like this like this
Emp Id : xyz
Emp Name : abc
-------------------------------------------------------
Child name Date of birth education
abc 12/12/2000 o levels
i have DropDownList with sql select commend
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource_department" DataTextField="Department"
DataValueField="Department_No" AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource_department" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [Department_No], [Department], [Code] FROM [Departments]">
</asp:SqlDataSource>
in the behind code, i can get the value using "DropDownList1.SelectedItem.Value" for Department_No and "DropDownList1.SelectedItem.Text" for Department
but i want also get the selected value "Code"
Im facing problem in one of the reports while passing multivalue parameter from ssrs to SP.
please note that in cases suppose there are single word in multivalue paramtere then its works corretly,in that scenario i have made one function see below:-
[Code]....
and did changes in sp as follow :-
[Code]....
im using ssrs2005.
How to write a MDX expression to pass the value of a multiselected filter while working with ReportAction in Cubes.
I know how to pass the currently selected value, but want to pass the more than one value selected in the filter.
I have created an ASP.NET page and included a ReportViewer on the page.
I have created a report with a parameter for an item ID for a row from the database.
After generating a multivalue parameter, I send it to the report, but only the first item in the list is displaying.
In my included code, I am using a FOR loop to generate a list of ID's I want to print a detail for (one detail per page), but eventually I am going to allow a user to select the ID's from a GridView, generate the reports and then print.
Here is the parameter definition from the report:
<ReportParameters>
<ReportParameter Name="ParmWorkOrderID">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_0</Prompt>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
---------
Here is the code that build the multivalue parameter:
List<ReportParameter> paramList = new List<ReportParameter>();
ReportParameter param = new ReportParameter("ParmWorkOrderID");
// Create the ArrayList of values to pass
ArrayList values = new ArrayList();
for (int i = 19; i < 50; i++)
{
param.Values.Add(i.ToString());
}
// Add the parameter to the list of ReportParameters
paramList.Add(param);
// Set the reports parameters
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] {param});
-------------------------------------------
Finally, here is the filter I have on the report:
<Filters>
<Filter>
<FilterExpression>=Fields!WorkOrderID.Value.ToString</FilterExpression>
<Operator>In</Operator>
<FilterValues>
<FilterValue>Parameters!ParmWorkOrderID.Value</FilterValue>
</FilterValues>
</Filter>
</Filters>
So, why won't the reporting engine pump out one page or row (if I use a table on the report) for each of the ID's sent over as parameters?
my qyery is Select * from UserTable .
i set my parameter as @UserId,checked multivalue check box.
in Available values-from query-i set my value and label field.
default value is null.
when i click the preview tab,multiple UserId with check box appear in drop down list...
when i select any one userid ..i get the result for all the userid list instead i want only the selected userid's information...
I once asked for a way to let a linkbutton pass more than one value in the commandArgument and then I reached the approach where I pass a string of multiple values separated by any character and split it into it's original parts...that didn't work out I don't know what was wrong with the splitting!
Now I tried the only solution I got, which is created a user control of the LinkButton and add properties to accept any values nedeed!...could you please tell me what's wrong with my 2 approaches and which is better ?
The first question can be found here : link text
and this is the code for the user control approach >>
MultivaluedLinkButton.ascx :
<asp:LinkButton ID="LnkBtnSort" runat="server" Text="Sort" OnClick="LnkBtnSort_Clicked"/>
MultivaluedLinkButton.ascx.cs :
public partial class MultivaluedLinkButton : System.Web.UI.UserControl
{
public event EventHandler Click;
private int _sortingType;
private string _sortingFactor;
private string _text;
public int SortingType
{
set { _sortingType = value; }
get { return _sortingType; }
}
public string SortingFactor
{
set { _sortingFactor = value; }
get { return _sortingFactor.ToString(); }
}
//public string Text
//{
// set { _text = value; }
// get { return _text.ToString(); }
//}
protected void LnkBtnSort_Clicked(object sender, EventArgs e)
{
if( Click != null )
{
this.Click(this, EventArgs.Empty);
}
}
}
Finally, Here's the implementation of my control inside an aspx page:
protected void MultivaluedLinkButton1_Clicked(object sender, EventArgs e)
{
MultivaluedLinkButton ctrl = (MultivaluedLinkButton)sender;
using (SqlConnection cn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
{
using (SqlCommand cm1 = new SqlCommand(commandString2, cn1))
{
cm1.Parameters.Add("@arrange_by_id", System.Data.SqlDbType.Int);
cm1.Parameters["@arrange_by_id"].Value = ctrl.SortingType;
cn1.Open();
using (SqlDataReader dr1 = cm1.ExecuteReader())
{
SortBy_rpt.DataSource = dr1;
SortBy_rpt.DataBind();
}
}
}
}
The item template of the repeater in the implementation page :
<ItemTemplate>
<uc1:MultivaluedLinkButton ID="MultivaluedLinkButton1" runat="server" OnClick="MultivaluedLinkButton1_Clicked" SortingType='<%#Eval("arrange_by_id")%>' />
</ItemTemplate>
I want to know, how do i send a multivalue parameter from C# to Stored Procedure which is used in WHERE CLAUSE in IN statement?
for eg:
CREATE PROCEDURE [dbo].[sp_GetPolicyDivOff1]
@Insid varchar(5000)=null
AS
SET NOCOUNT ON
SELECT MST_GroupCompany.GC_Name,MST_DivisionalOffice.DIV_Name FROM MST_DivisionalOffice INNER JOIN MST_GroupCompany ON
MST_DivisionalOffice.DIV_FK_GC_ID=MST_GroupCompany.GC_ID where GC_Name IN(@Insid)
i have dataset with two data tables inside
dt1
dt2
i want to bind data from both data table t gridview
for this how can i make join between two data tables inside dataset and retreive data
How to display empty GridView to insert new record if no data retreived for some record on the result from data table?Actually i am trying to give a user an option to add recrod from Gridview. On result of some query it is perfectly displaying data and a footer row with the insertion textbox but when there is no data in the gridview it is not displaying. It should display with footer having insert textbox.
View 5 RepliesI have a datagridview control that I'm using to display cache data to the end used on a web form. The issue that I'm having is that every time I re-run the application, and the cache data is re-generated... it loads duplicate data that's being displayed to the end user. I can't seem to figure out how to keep this from happening.
What I would like to have happen is that only unique data rows be returned and cached for the end user. Unless there are new data rows on the database that needs to be included in the cache data results...the previous data results should not be duplicated. I've tried to change a few properties on the datagridview control, but nothing seem to keep this from happening.
[code]....
I have a listview control bound to an SqlDataSource. As part of the formatting I want to add a title to the data returned from my database. For instance if the data base returns a phone number I want to add 'Tel.' first. However I do not want to diplay this
title if the datafield is empty. Here is what I have done so far.
<ItemTemplate>
<asp:Label ID="BusinessLabel" runat="server" Text='<%# "Tel. "+Eval("Business") %>' CssClass="TeleStyle" />
Or This:Tel.
<asp:Label ID="BusinessLabel" runat="server" Text='<%# Eval("Business") %>' CssClass="TeleStyle" />
</ItemTemplate>
Business is a phone number. If the data field contains a number I get: Tel. 1234 123456. If the field is empty I get Tel. If Business is null I want nothing dsplayed, how do I do this?
Using a class component, an Object data source and a formview I am successfully pulliing data from a SQL database. In some cases the rows contain one or more Null values and I would like them to be ignored completely. My simple code follows:-
<%# Eval("add_1") & ","%>
<%# Eval("Add_2") & ","%>
<%# Eval("Add_3") & ","%>
OUTPUT:-
Rose Cottage, 123 New Road, Margate,
I developed a web site more then a year ago with .net2.0/c#/mssql 2005. it works fine but i was asked to replace mssql with mysql.
I wrote a class to complete data access works (unfortunately, I didnt use nhibernate or other data access tools :((
I edited the class to use System.Data.Odbc objects rather than System.Data.SqlClient.
It works fine in selecting data but not manipulating data. when i try to insert new data it adds null data for all fields in the table.
in debug mode, i noticed that it might be caused by OdbcParameter but not sure.
My griedview code :-
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" RowStyle-BackColor="Black" Font-Names = "Arial" Font-Size = "10pt"
HeaderStyle-BackColor="Black" HeaderStyle-ForeColor="Black" ForeColor="Black" AllowPaging ="true"
OnPageIndexChanging = "OnPaging" PageSize = "5">
[Code] ....
Error is:- The data source does not support server-side data paging.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception
Details: System.NotSupportedException: The data source does not support server-side data paging.
Source Error:
Line 34: con.Open();
Line 35: GridView1.DataSource = cmd.ExecuteReader();
Line 36: GridView1.DataBind(); Line 37: con.Close();
Line 38: }
i have 103 column in database 1 column is id, 1 is user ,1 datetime, 100 button on webpage 1 textbox to input value , button1 clicked then value in textbox will insert into database with user:=user.identity.nam datetime=datetime.now colum4 will get value from textbox......button2 for colum2 and buton100 for column100, if i use dataset i need 100 datataset, some other way to solve it ??
View 2 RepliesI would like to add a column in my datagridview that takes the value from the database and asigns it to the text of a linkbutton or make it a hyperlink. i know how to handle getting the value from the row but dont
know how to make a value a link, or set the text to a link button
I am referring this article :
[URL]
now when i type something in header Search cell , it shows the data of first page index only , it won't show me data from 2nd page index .. here's my code :
protected void PhasesTempGrid_OnDataBound(object sender, EventArgs e){
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
for (int i = 0; i < PhasesTempGrid.Columns.Count - 1; i++) {
TableHeaderCell cell = new TableHeaderCell();
TextBox txtSearch = new TextBox();
[Code] .....
My gridview is in update panel therefore i did this in .js script :
var prm = Sys.WebForms.PageRequestManager.getInstance();
prm.add_endRequest(function () {
$(document).ready(function () {
$('.search_textbox').each(function (i) {
[Code] .....
Here's my code structure for gridview :
<asp:UpdatePanel ID="ConstructionActPhaseUpdatePanel" UpdateMode="Conditional" runat="server">
<ContentTemplate>
<asp:gridview ID="PhasesTempGrid" ClientIDMode="Static" OnDataBound="PhasesTempGrid_OnDataBound" allowpaging="True" OnPageIndexChanging="PhasesTempGrid_OnPageIndexChanging"
[code]...
and the way i bind the data to gridview is from textboxes ....
[URL].....
in one on my page i am using to add the data from popup window to grid view without using the backend means databasethis is my popup window code
[Code]....
[Code]....
I would like to dropdown box to show only starting from second row of the table. How to use data reader to do it?
View 9 Replies.I have a search page where I would search for an item and it would dispaly the results in a gridview...
I have allowed paging and set page size to 10..now I can see the 10 results in the first page and also see the page numbers at the bottom of gridview. But now when i click on the page 2, the method gridview_pageindexchanging is triggered but the result set is not dispalyed. My code is as below..
[code]....
i understand that the data is not binding in the GridView1_PageIndexChanging method..I do not know how can I make data bind..
I have a many to many table in my database called PeopleLanguage
PeopleId, pk and Languags pk each go to the own table People and Language
I know make a method call with my objectdatasource GetPeopleByLanguageId
This returns the languages that the selected person speaks and has a select
query also to lanaguageTable to get LanguageName.
I now print out the results in a datalist that is binding to LanguageName.
What i want to do is show the languages in a horizontal format with a comma after each one.
At the moment if there are 3 languages it shows each one on a seperate line / if I make it horizontal
layout I still dont get a comma. Perhaps I can use a repeater?
I am trying to debug one of the project in which i need to show the data for one of the particular cell in two lines.
This Repeator control Exists in a user control and aspx is calling this User control for displaying the data.
Here is how my code looks:
[Code]....