|
Hey,
I have a database and it contains article table so this table contains two field named Header and Content. Then i wanna show this data in a gridview control but there are two pages. the first one contains just label which is used to show any article's header and another label which is used to show some piece of article's content text. But how can i show some piece of article's content text to the user. For example i wanna get 5000 letters from begining of an article's content which is preserved in database.It is said there is an query to handle this.But i couldnt find that query.
Please help me. Thanks and regards..
|
|
|
|
|
Use the SUBSTRING function (or SUBSTR for Oracle) like
SELECT header, SUBSTRING(content, 0, 5000)
|
|
|
|
|
Thanks man 
|
|
|
|
|
Hi,
i used the custom sqlsitemapprovider which is in this web : http://msdn.microsoft.com/msdnmag/issues/06/02/wickedcode/default.aspx?loc=&fig=true#fig5 but in this sample they used sqlsitemapprovider as a default sitemapprovider i dont wanna use it as a default and i wanna send a paramater which is used to filter datas to that class. I modified that class and i can take a sitemapprovider back and i wanna show it a sitemappath data source programmaticaly. i wanna create an instance object of sitemappath datasource and i wanna bind it to that class and then i wanna add a treeview control to the page then i wanna bind it to the sitemapdatasource programmaticaly too..
Thanks for your attetion.
Regards...
|
|
|
|
|
Ok i made it 
if you wanna learn how i made it :
just write them written below in the specified area :
in web.config:
<connectionstrings>
<add name="SiteMapConnectionString" connectionstring="Data Source=.;Initial Catalog=Sorular;Integrated Security=True;Pooling=False" providername="System.Data.SqlClient">
<system.web>
<caching>
<sqlcachedependency enabled="true">
<sitemap>
<providers>
<add name="SiteMapBenYazdim" type="SqlSiteMapProvider" connectionstringname="SiteMapConnectionString">
codebehind:
SiteMapDataSource data = new SiteMapDataSource();
data.SiteMapProvider = "SiteMapBenYazdim";
TreeView1.DataSource = data;
TreeNodeBinding bind = new TreeNodeBinding();
bind.TextField = "Title";
bind.ToolTipField = "Description";
bind.ValueField = "Url";
bind.SelectAction = TreeNodeSelectAction.SelectExpand;
TreeView1.DataBindings.Add(bind);
That it man.i have been working on that damn thing about 2 days. And thanks God :-> finally i made it..
|
|
|
|
|
<asp:gridview id="GridView1" allowpaging="True" runat="server"
="" datasourceid="SqlDataSource1" datakeynames="au_id" autogeneratecolumns="False" width="600px" onselectedindexchanged="GridView1_SelectedIndexChanged" onsorted="GridView1_Sorted" onpageindexchanged="GridView1_PageIndexChanged">
<columns>
<asp:commandfield showselectbutton="True">
<asp:boundfield datafield="au_id" headertext="au_id" readonly="True" sortexpression="au_id">
<asp:boundfield datafield="au_lname" headertext="au_lname" sortexpression="au_lname">
<asp:boundfield datafield="au_fname" headertext="au_fname" sortexpression="au_fname">
<asp:boundfield datafield="state" headertext="state" sortexpression="state">
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:pubsConnectionString %>"
="" selectcommand="SELECT [au_id], [au_lname], [au_fname], [state] FROM [authors] WHERE [state] = @state">
<selectparameters>
<asp:controlparameter controlid="DropDownList1" name="state" propertyname="SelectedValue"
="" type="String">
This is haneef.............................................................
|
|
|
|
|
"Select au_id,au_Iname etc. from authors where state = "+Request.QueryString["YourQueryStringKeyName"];
Hope it helps, enjoy.
|
|
|
|
|
|
1. You only have to post the question once.
2. The subject line is for a short description, not for your entire question.
3. If you write your question in the body of the post, you might be able to elaborate enough for someone to actually understand the question.
4. Most of your code seems to be missing. Use the "Ignore HTML" option when posting markup code.
---
single minded; short sighted; long gone;
|
|
|
|
|
<asp:gridview id="GridView1" allowpaging="True" runat="server"
="" datasourceid="SqlDataSource1" datakeynames="au_id" autogeneratecolumns="False" width="600px" onselectedindexchanged="GridView1_SelectedIndexChanged" onsorted="GridView1_Sorted" onpageindexchanged="GridView1_PageIndexChanged">
<columns>
<asp:commandfield showselectbutton="True">
<asp:boundfield datafield="au_id" headertext="au_id" readonly="True" sortexpression="au_id">
<asp:boundfield datafield="au_lname" headertext="au_lname" sortexpression="au_lname">
<asp:boundfield datafield="au_fname" headertext="au_fname" sortexpression="au_fname">
<asp:boundfield datafield="state" headertext="state" sortexpression="state">
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:pubsConnectionString %>"
="" selectcommand="SELECT [au_id], [au_lname], [au_fname], [state] FROM [authors] WHERE [state] = @state">
<selectparameters>
<asp:controlparameter controlid="DropDownList1" name="state" propertyname="SelectedValue"
="" type="String">
This is haneef.............................................................
|
|
|
|
|
<asp:gridview id="GridView1" runat="server" cellpadding="4" forecolor="#333333" gridlines="None"
="" height="256px" style="left: 0px; position: relative; top: 0px" width="640px" datakeynames="au_id">
<footerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<rowstyle backcolor="#F7F6F3" forecolor="#333333">
<editrowstyle backcolor="#999999">
<selectedrowstyle backcolor="#E2DED6" font-bold="True" forecolor="#333333">
<pagerstyle backcolor="#284775" forecolor="White" horizontalalign="Center">
<headerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<alternatingrowstyle backcolor="White" forecolor="#284775">
<columns>
<asp:commandfield showselectbutton="True">
<asp:boundfield datafield="au_id" headertext="au_id" readonly="True" sortexpression="au_id">
<asp:boundfield datafield="au_lname" headertext="au_lname" readonly="True" sortexpression="au_lname">
<asp:boundfield datafield="au_fname" headertext="au_fname" readonly="True" sortexpression="au_fname">
This is haneef.............................................................
|
|
|
|
|
Plz help me .. how can i use directX.sound 4 recording sound ..?
i wanna any Example or tutorial plzzzzzzzzz ..
i haven't used DirectX before  ..
|
|
|
|
|
You really can't, not in an ASP.NET application.
There are plenty of examples on this site, and also in the SDK itself.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi ,
Is there any way in-built in RequiredFieldValidator control by which we can change the backcolor of the empty textboxes which is being validated by RequiredFieldValidator Coltrol upon the validation to differentiate from other entered fields..? If not any other work arounds?
Thx.
Regs
Mohan
|
|
|
|
|
just user font tag or class for ex:
<asp:requirefieldvalidator runat="server" ....="">if you are using stylesheet use like below
<asp:requirefieldvalidator runat="server" ....="">
This is haneef.............................................................
|
|
|
|
|
thx, But my scenario is i need to change the backcolor if and only the text boxes are empty.
i.e only when RequiredFieldValidtor is blinking.
|
|
|
|
|
how i can write some data on exiting xml file without deleting its previous saved data on it.
i want to know also how to delete an element, for example assume i have an xml file with these data:
<city>
<name>Mog</name>
<time>3:3</time>
</city>
<city>
<name>ter</name>
<time>56:3</time>
</city>
i want to delete the city with the name mog, so i mean i want to delete the first 4 lines of the above given example
please help help
Thanks alot
Hamody
|
|
|
|
|
The XmlDocument class is what you need, it allows you to modify XML using a well defined interface ( called the Document Object Model or DOM ).
You'd use XPath to search for the city whose name is Mog, then remove it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
thnx, i did it, but please i need another help, i want to add datagridview and make its data source from xml file, i did up to this thing but i want to add a cloumn which will contain a hyperlinks, how to add hyperlinks on the datagridview on the windows projects 
Thanks alot
Hamody
|
|
|
|
|
I've not used that before, can you define the column formats like you do in ASP.NET ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I am writing a crystal report webform. I ve droped my reportviewer control on teh form .I also have my .rpt file in the Reports subfolder of my project's root folder. I specify the report source as follows
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim oReport As New ReportDocument
oReport.Load(".\Reports\ProjList.rpt")
oViewer1.ReportSource = oReport
oViewer1.DataBind()
but it gives teh error
The system cannot find the file specified.
I changed the backslash to fron slash,
also i used mappath() function
no head way
any help will be appreciated
t.aransiola
|
|
|
|
|
oReport.Load(server.mappath(".\Reports\ProjList.rpt"))
|
|
|
|
|
hello;
I am using asp.net 2.0
I have problem with using fileupload control
its work fine with textfile and images
but i have tried for example to upload pdf file
but it dose not work
this code
String path = Request.PhysicalApplicationPath;
path += FileUpload1.FileName;
FileUpload1.SaveAs(path);
aj123
|
|
|
|
|
Standard question #1:
What do you mean by "not working"?
Standard question #2:
What error message do you get?
---
single minded; short sighted; long gone;
|
|
|
|
|
there is no error I get just empty webpage display
aj123
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
