|
retrive data from sql database to a gridview, then how to use search option in a gridview ?
|
|
|
|
|
use this code it will help u
private DataTable GetRecords()
{
conn.ConnectionString = "User ID=sa;Data Source=(local);Database=inventry";
//SqlConnection conn = new SqlConnection(strConnection);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select ptype,pqty from total_stock";
SqlDataAdapter dAdapter = new SqlDataAdapter();
dAdapter.SelectCommand = cmd;
DataSet objDs = new DataSet();
dAdapter.Fill(objDs);
return objDs.Tables[0];
}
private void BindGrid()
{
DataTable dt = GetRecords();
if (dt.Rows.Count > 0)
{
grdSearch.DataSource = dt;
grdSearch.DataBind();
}
}
private void SearchText()
{
DataTable dt = GetRecords();
DataView dv = new DataView(dt);
string SearchExpression = null;
if (!String.IsNullOrEmpty(txtSearch.Text))
{
SearchExpression = string.Format("{0} '%{1}%'",
grdSearch.SortExpression, txtSearch.Text);
}
dv.RowFilter = "ptype like" + SearchExpression;
grdSearch.DataSource = dv;
grdSearch.DataBind();
}
public string Highlight(string InputTxt)
{
string Search_Str = txtSearch.Text.ToString();
// Setup the regular expression and add the Or operator.
Regex RegExp = new Regex(Search_Str.Replace(" ", "|").Trim(),
RegexOptions.IgnoreCase);
// Highlight keywords by calling the
//delegate each time a keyword is found
return RegExp.Replace(InputTxt, new MatchEvaluator(ReplaceKeyWords));
// Set the RegExp to null.
RegExp = null;
}
public string ReplaceKeyWords(Match m)
{
return "<span class=highlight>" + m.Value + "</span>";
}
protected void txtSearch_TextChanged(object sender, EventArgs e)
{
SearchText();
}
|
|
|
|
|
DataTable dt = GetYourDataTable(); //Write code to get data from your database.
DataView dv = new DataView(dt);
dv.RowFilter = ""City = 'New York'"; //Write your filter condition
GridView1.DataSource = dv;
GridView1.DataBind();
|
|
|
|
|
|
i want to convert sql data to Text.txt Format , How it Posible?
|
|
|
|
|
First, this question is not related to asp.net.
If you want to convert SQL Server data into text format, you can use export/import feature available in the SQL Server Management Studio.
|
|
|
|
|
Hi all!!!
I have a problem wich conversion format DateTime.
I create AjaxCalendar UserControl, an use it in my page, and I have a conversion format DateTime:
<br />
protected void AjaxCalendar_DataBinding(object sender, EventArgs e) {<br />
try {<br />
DateTime time = DateTime.Parse(TextDate.Text, new CultureInfo("en-GB"));<br />
}<br />
catch (Exception) {<br />
TextDate.Text = string.Empty;<br />
return;<br />
}<br />
}<br />
and asp code of User Control:
<asp:TextBox ID="TextDate" runat="server" Width="70px" />
<Ajax:CalendarExtender ID="AjaxCalendar" runat="server" TargetControlID="TextDate" Format="dd/MM/yyyy" OnLoad="AjaxCalendar_DataBinding"/>
I load from database and add to database datatime from this control. When I use Visual Studio (I use Visual Studio 2008) this conversion work fine, but when i put my project page on IIS or on Server this conversion not work, and i obtain "String.Empty".
If I block this code I obtain data in format MM/dd/yyyy. In Regional Options i have selected format English and stat United Kingdom.
I write implicit conversion in this Mode ...ToString("dd/MM/yyyy") looks fine, but when i wont to add data in database with datetime i obtain error on dateTime.
Help me, PLEASE to create a conversion function or else, for work in IIS, or on Server.
|
|
|
|
|
hi
i m using asp.net with c# and trying to edit gridview but it's give error
Must declare the variable '@pname'.
my code is
<asp:SqlDataSource ID="SqlDataSource1" Runat="server" ConnectionString="<%$ ConnectionStrings:mcplconnectionstring2 %>"
UpdateCommand="UPDATE [mat_in] SET [pname] = @pname, [qty] = @qty, [sno_to] = @sno_to,[sno_from]=@sno_from WHERE [materialrecipt_no] = @materialrecipt_no"
SelectCommand="SELECT [materialrecipt_no],[pname],[qty],[sno_to],[sno_from] FROM [mat_in]">
<UpdateParameters>
<asp:Parameter Type="string" Name="ProductName"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Quantity"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Sr No(Start)"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Sr No(End)"></asp:Parameter>
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" Runat="server" BorderColor="#3366CC" BorderStyle="None" CellPadding="4" BackColor="White"
BorderWidth="1px" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="materialrecipt_no" DataSourceID="SqlDataSource1">
<FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle>
<PagerStyle ForeColor="#003399" HorizontalAlign="Left" BackColor="#99CCCC"></PagerStyle>
<HeaderStyle ForeColor="#CCCCFF" Font-Bold="True" BackColor="#003399"></HeaderStyle>
<Columns>
<asp:CommandField ShowEditButton="True"></asp:CommandField>
<asp:BoundField ReadOnly="True" HeaderText="materialrecipt no" InsertVisible="False" DataField="materialrecipt_no"
SortExpression="materialrecipt_no"></asp:BoundField>
<asp:TemplateField SortExpression="ProductName" HeaderText="Product"><EditItemTemplate>
<asp:DropDownList ID="editProductName" Runat="server" DataSourceID="SqlDataSource1" DataTextField="pname"
DataValueField="pname" Text='<%# Bind("pname") %>'></asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" Runat="server" ErrorMessage="You must provide a Product Name."
ControlToValidate="editProductName">
*</asp:RequiredFieldValidator>
</EditItemTemplate>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("pname") %>' ID="Label3"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="materialrecipt_no" HeaderText="Sr No"><EditItemTemplate>
<asp:TextBox ID="editUn" Runat="server" Text='<%# Bind("materialrecipt_no") %>' Columns="6">
</asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("materialrecipt_no") %>' ID="Label4"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="qty" HeaderText="Quantity"><EditItemTemplate>
<asp:TextBox ID="editUnitPrice" Runat="server" Text='<%# Bind("qty") %>' Columns="6">
</asp:TextBox>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("qty") %>' ID="Label1"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="srno_to" HeaderText="Sr No(End)"><EditItemTemplate>
<asp:TextBox ID="editUnitsInStock" Runat="server" Text='<%# Bind("sno_to") %>' Columns="4"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator2" Runat="server" ErrorMessage="You must provide a valid integer for Units In Stock."
ControlToValidate="editUnitsInStock" Operator="DataTypeCheck" Type="Integer">
*</asp:CompareValidator>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("sno_to") %>' ID="Label2"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="srno_from" HeaderText="Sr No(Start)"><EditItemTemplate>
<asp:TextBox ID="editUnitsInsr" Runat="server" Text='<%# Bind("sno_from") %>' Columns="4"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator3" Runat="server" ErrorMessage="You must provide a valid integer for Units In Stock."
ControlToValidate="editUnitsInsr" Operator="DataTypeCheck" Type="Integer">
*</asp:CompareValidator>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("sno_from") %>' ID="Label3"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<SelectedRowStyle ForeColor="#CCFF99" Font-Bold="True" BackColor="#009999"></SelectedRowStyle>
<RowStyle ForeColor="#003399" BackColor="White"></RowStyle>
</asp:GridView>
pls help me
thanks in advance
|
|
|
|
|
Name of parameter should be "pname" not a "ProductName".
<asp:Parameter Type="string" Name="ProductName"></asp:Parameter>
<asp:Parameter Type="string" Name="pname"></asp:Parameter>
A DATAPOST COMPUTER CENTRE
(K.V Prajapati)
|
|
|
|
|
I have a gridview with autogeneratecolumn false.I have bind it with a data table dt.In dt there is a column named as "status" whose data type i bit.that means status can take either 0 or1.in gridview this column shows true or false.
I want to show "Read" and "Unread" for 0,1 respectively.
How can I do???
plz..help...
|
|
|
|
|
In GridView1_RowDataBound(),
try this,
if (e.Row.Cells[1].Text == "0")
{
e.Row.Cells[1].Text = "Read";
}
|
|
|
|
|
Use the GridView RowDataBound Event Delegate to change the value of one cell.
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)<br />
{<br />
e.Row.Cells[0].Text = e.Row.Cells[0].Text == "0" ? "Unread" : "Read";<br />
}
Happy Coding...
|
|
|
|
|
You can also use case in query at time of retrieving data from database :-
For Example:-
case status when '0' then 'Unread' else 'Read' end as status
|
|
|
|
|
hiii
i m using asp.net
and facing problem in edit time,when i click on edit button all field are readonly they are not change in textbox(editable mode).
code is
<asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#E7E7FF"
BorderStyle="None" BorderWidth="1px" CellPadding="3"
GridLines="Horizontal" DataKeyNames="materialrecipt_no" PageSize="20"
Style="position: relative" Width="1064px"
AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
OnRowEditing="GridView1_RowEditing" AllowPaging="True">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True"
ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C"
HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True"
ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="materialrecipt_no"
HeaderText="Sr No" InsertVisible="False"
ReadOnly="True" SortExpression="materialrecipt_no" />
<asp:BoundField DataField="materialrecipt_date"
HeaderText="Entry Date"
SortExpression="materialrecipt_date" />
<asp:BoundField DataField="pname" HeaderText="Product
Name" SortExpression="pname" />
<asp:BoundField DataField="qty" HeaderText="Quantity"
SortExpression="qty" />
<asp:BoundField DataField="enterby" HeaderText="Enter By"
SortExpression="enterby" />
<asp:BoundField DataField="sno_to" HeaderText="Sr
No(End)" SortExpression="sno_to" />
<asp:BoundField DataField="sno_from" HeaderText="Sr
No(Start)" SortExpression="sno_from" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:mcplConnectionString2 %>"
SelectCommand="SELECT * FROM [mat_in] ORDER BY
[materialrecipt_no] DESC"
UpdateCommand="Update [mat_in] set
[pname]=@pname,[qty]=@qty,[enterby]=@enterby,[sno_to]=@sno_to,[sno_from]=@sno_from
where [materialrecipt_no]=@materialrecipt_no"
></asp:SqlDataSource>
|
|
|
|
|
Post you server code also
|
|
|
|
|
Hi all,
i have deployed a site where a i am reading the username using User.Identity.Name.Remove(0, User.Identity.Name.IndexOf("\") + 1) and then validate this username in active directory. if exist proceed. Locally it is working well however when iam deploying iam disabling anonymous and checking only windows integrated security the first time i input the url a username and password is popping.
What i need is not to pop up this message and directly enter the site if validated.
Any sugesstions, thanks
|
|
|
|
|
Apperently, you also have Basic Authentication enabled. You need to disable it.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Thanks for ur reply.
No iam only enabling windows integrated and the popup msg is only showing the first time i enter the application URL.
|
|
|
|
|
Hi,
any body worked on ibm language ware,if worked pls suggest
how to integrate sql server to ibm language ware,it uses derby instead i want to integrate it to sql server..
pavithramukesh
|
|
|
|
|
pavithramukesh wrote: any body worked on ibm language ware,if worked pls suggest
What does it has do with ASP.Net?
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
i need use that with my .net project
|
|
|
|
|
Can we show the big size[200 MB] Video in the Web Site?. if it , can we show in the embeded control or is there any other control or easy technic for this.
|
|
|
|
|
Ofcourse you can! I don't know the length of the video, visitors of your website have to download the 200 MB of video to view the entire video. If the video is long enough to download the 200 Mb while playing you're fine, else the video will stop playing when the buffer is empty and start buffering the next part of the video. You may consider if this is actually what you want, you're going to use loads of bandwith when your website has a lot of visitors.
For embedding, try silverlight! I even managed to create my own video player with silverlight. If I can do it... You can
|
|
|
|
|
This is an around one hour video. what is silverlight, can i get some sample codes or helping links?
|
|
|
|
|
Can anybody help me
i am developing an online examination system
i want to display Questions one by one
how i can use move next,move previous,move last,move first
|
|
|
|