ASP.NET Discussion Boards

Re: Post an HTTP Request from one WebServer to another server.

N a v a n e e t h23-Sep-09 1:05

N a v a n e e t h

23-Sep-09 1:05

Most easy way to get a response from a URI is to use WebClient[^] class.

Navaneeth

How to use google | Ask smart questions

How to Supress the Sub Report when there is no data in Crystal Reports

arulselvanS23-Sep-09 0:15

arulselvanS

23-Sep-09 0:15

In perticular date the main report have record but subreport have no record.In this situation the subreport retrieve all the data from table.
How to supress sub report when this situation. Please help me..........

Re: How to Supress the Sub Report when there is no data in Crystal Reports

sashidhar23-Sep-09 1:09

sashidhar

23-Sep-09 1:09

I think Here U Will Not Get Most Help For reports Questions I suggest U to Post In General DataBase Or Different Forums .I am Telling U this With My Own Experience..! Cool | :cool:

If It Helps Click It as Answer

LINQ Disadvantages

sris 42622-Sep-09 23:56

sris 426

22-Sep-09 23:56

Can Any One expain the dis advantaged of LINQ,like where i Can use and where I can not...
Thanks,
Srinivas Mateti

Re: LINQ Disadvantages

S.Dhanasekaran23-Sep-09 0:03

S.Dhanasekaran

23-Sep-09 0:03

Disadvantages of LINQ over Stored Procedures
-----------------------------------------------

1) Network traffic: sprocs need only serialize sproc-name and argument data over the wire while LINQ sends the entire query. This can get really bad if the queries are very complex. However, LINQ's abstraction allows Microsoft to improve this over time.

2) Less flexible: Sprocs can take full advantage of a database's featureset. LINQ tends to be more generic in it's support. This is common in any kind of language abstraction (e.g. C# vs assembler).

3) Recompiling: If you need to make changes to the way you do data access, you need to recompile, version, and redeploy your assembly. Sprocs can sometimes allow a DBA to tune the data access routine without a need to redeploy anything.

Re: LINQ Disadvantages

N a v a n e e t h23-Sep-09 0:46

N a v a n e e t h

23-Sep-09 0:46

S.Dhanasekaran wrote:
Disadvantages of LINQ over Stored Procedures

How a comparison is possible between LINQ and Stored Procedures?

Navaneeth

How to use google | Ask smart questions

Re: LINQ Disadvantages

Manas Bhardwaj23-Sep-09 0:04

Manas Bhardwaj

23-Sep-09 0:04

sris 426 wrote:
Can Any One expain the dis advantaged of LINQ

In ASP.Net Forum? OMG | :OMG:

I would have chosen LINQ [^]forum forum for that

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: LINQ Disadvantages

Vimalsoft(Pty) Ltd23-Sep-09 1:34

Vimalsoft(Pty) Ltd

23-Sep-09 1:34

I dont want my Data Layer to Contain SQL Manupilation. Linq does that. I like Linq to Object. Am not a Fan of Linq to SQL

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: LINQ Disadvantages

sris 42623-Sep-09 1:58

sris 426

23-Sep-09 1:58

What About LINQ to XML and other options? I am using linq to load and process XML file? Will it give any extra burden to Application. Please advise.....

Thanks in advance
Srinivas Mateti

Re: LINQ Disadvantages

S.Dhanasekaran23-Sep-09 2:32

S.Dhanasekaran

23-Sep-09 2:32

Anyhow, you are somewhat comparing apples and oranges. LINQ to XML (and LINQ in general) is a query language whereas XSLT is a programming language to transform XML tree structures. These are different concepts. You would use a query language whenever you want to extract a certain specific piece of information from a data source to do whatever you need to do with it (be it to set fields in a C# object). A transformation, in contrast, would be useful to convert one XML representation of your data into another XML representation.

So if your aim is to create C# objects from XML, you probably don't want to use XSLT but any of the other technologies offered by the .NET Framework to process XML data: the old XmlDocument, XmlReader, XPathDocument, XmlSerializer or XDocument. Each has it's special advantages and disadvantages, depending on input size, input complexity, desired output etc.

Re: LINQ Disadvantages

Not Active23-Sep-09 2:27

Not Active

23-Sep-09 2:27

Vuyiswa Maseko wrote:
I dont want my Data Layer to Contain SQL Manupilation.

So what does your data layer contain?

only two letters away from being an asset

Re: LINQ Disadvantages

Vimalsoft(Pty) Ltd23-Sep-09 2:41

Vimalsoft(Pty) Ltd

23-Sep-09 2:41

In my Data Layer i call the SP that does the Necessary manupilation. What i mean is that you will never Find select statements in my Data Layer.

Printing at specfic point at page

Thekaninos22-Sep-09 22:53

Thekaninos

22-Sep-09 22:53

Hello!

I'm kinda new to ASP.net so i am just testing and failing, so maybe the approach i am going for is just wrong if so tell me =)

I'm trying to print a sequence of HTML code with Response.Write ... works fine enough, but i am interested in printing this code at a specific point on the page...

Currently i am trying to do that from the class with the method Page_Load, with the event of a button click...

Don't know if that explain it..

Re: Printing at specfic point at page

N a v a n e e t h22-Sep-09 23:57

N a v a n e e t h

22-Sep-09 23:57

Thekaninos wrote:
but i am interested in printing this code at a specific point on the page...

Put a literal control on the area where you need it to be printed. Set the HTML code to literal's Text property.

Navaneeth

How to use google | Ask smart questions

Resource file in .net

monika_vasvani22-Sep-09 22:44

monika_vasvani

22-Sep-09 22:44

Hello

I am developing one web application.I want to use language options for this application.

I have gone through resource files but i didn't get one point which is

how to add values into different language means i add string as Name how to

convert name into French language into value.and My full site has 50 pages how to convert each and every page string values through resource file.

Pls explain me in details if u know this point.

Thanks.

Re: Resource file in .net

S.Dhanasekaran22-Sep-09 23:33

S.Dhanasekaran

22-Sep-09 23:33

Try below link

Creating multilingual websites[^]

Creating multilingual application[^]

gridview date sorting in asp.net?????????????????

srinivassam22-Sep-09 21:33

srinivassam

22-Sep-09 21:33

Hi all,

I have one doubt, i am fetching data from database and i am displaying data in gridview.(select empid,empno,covert(varchar,dateofbith,101),convert(varchar,joiningdate,101) from emptable) (values are:1,12,'12/31/1986','12/31/2008')

i am not using any boundfields in gridview.

i am using this code to sort the gridview columns,everything is working fine but dateofbirth,joiningdate fields sorting is not working .

i am using below code to sort the gridview columns:
If Not (Page.IsPostBack) Then
ViewState("Sort") = "asc"
end if

and

Protected Sub grdCommon_Sorting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSortEventArgs) Handles grdCommon.Sorting
Try

grdCommon.DataSource = Session("grdCommon")
grdCommon.DataBind()

Dim dataTable As DataTable = CType(grdCommon.DataSource, DataTable) ' DirectCast(ViewState("grdCommon.DataSource"), DataTable)
Dim dataView As DataView = New DataView(dataTable)

If Not (dataView Is Nothing) Then
If ViewState("Sort").ToString() = " asc" Then
ViewState("Sort") = " desc"
Else
ViewState("Sort") = " asc"
End If
dataView.Sort = e.SortExpression + ViewState("Sort").ToString()
grdCommon.DataSource = dataView
ViewState("grdCommon.DataSource") = dataView.Table
grdCommon.DataBind()
End If
end sub

Regards
Rama

samrama

Re: gridview date sorting in asp.net?????????????????

S.Dhanasekaran22-Sep-09 23:59

S.Dhanasekaran

22-Sep-09 23:59

hi,

Here i add a sample code for sorting

1) In Gridview Properties add this

AllowSorting="true" OnSorting="gridView1_OnSorting"

2) In gridView use TemplateField Column

<asp:TemplateField HeaderText="joiningdate" HeaderStyle-HorizontalAlign="Left" SortExpression="joiningdate" ItemStyle-Width="30%">
<ItemTemplate >
<span id="joiningdate" runat="server" style="color:Black;" ><%#Eval("joiningdate") %></span>
</ItemTemplate>
</asp:TemplateField>

3) create a Event gridView1_Onsorting

protected void gridView1_OnSorting(object sender, GridViewSortEventArgs e)
{
string sortExpression = e.SortExpression;
ViewState["sortExpression"] = e.SortExpression;
if (GridViewSortDirection == SortDirection.Ascending)
{
GridViewSortDirection = SortDirection.Descending;
SortGridView(sortExpression, "DESC");
}
else
{
GridViewSortDirection = SortDirection.Ascending;
SortGridView(sortExpression, "ASC");
}
}

4) Create a SortGridView() Method

private void SortGridView(string sortExpression, string direction)
{
DataTable dt = null;
dt = "test" // fill the Datatable rows using sqlcommand or Dataset
DataView dv = new DataView(dt);
dv.Sort = sortExpression + " " + direction;
gridView1.DataSource = dv;
gridView1.DataBind();
}

5) Create a enum SortDirection

public SortDirection GridViewSortDirection
{
get
{
if (ViewState["sortDirection"] == null)
ViewState["sortDirection"] = SortDirection.Ascending;
return (SortDirection)ViewState["sortDirection"];
}
set { ViewState["sortDirection"] = value; }
}

Save data from a html table to database

yesu prakash22-Sep-09 21:15

yesu prakash

22-Sep-09 21:15

Hi,
How to save data from a html table to database.
eg: my html table, it is dynamically generated using string concadination

name age address city
N1 10 xyz abc
N2 20 abc xyz

I need to read this html table and save it to database
How to do this?

Thankyou
YPKI

Re: Save data from a html table to database

Abhishek Sur23-Sep-09 0:03

Abhishek Sur

23-Sep-09 0:03

Say you paste the html into a container div. Now you can get the inner HTML in the server side of the div. Now parse the table from it.

Otherwise if you like to create the entire htmlTable with view state and all, you need to create the object during pre_Init.

Smile | :)

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

DATASET refresh every second - problem

j_u_sankar22-Sep-09 20:43

j_u_sankar

22-Sep-09 20:43

This is the chat box where every second gets refresh with AJAX. But,here the dataset (ds) is filled by other order detail, lead to get wrong messages in the chat box.

How to fill ds for every second from SQL database without conflict?

VB Code

lsSQL = "select MSG_Message from tbl_message where MSG_Orderno='" & orderno & "' order by MSG_ID"
                        Dim DtSqlAdp6 As New SqlClient.SqlDataAdapter(lsSQL, DbCon)
                        DtSqlAdp6.Fill(ds)

Re: DATASET refresh every second - problem

Vimalsoft(Pty) Ltd23-Sep-09 0:29

Vimalsoft(Pty) Ltd

23-Sep-09 0:29

Good Day j_u_sankar

There is Probably a better way of doing this, but anyway. To Clear the dataset you must Add the Following code

DtSqlAdp6.Clear()

before you fill the dataset.

Crystal Sub-report displaying the redundant records...

jmk_cooljack22-Sep-09 20:42

jmk_cooljack

22-Sep-09 20:42

Dear Experts,

i've designed a crystal report and embedded a sub report in it, the sub report needs to display some 7 records (i.e 7 lines), the design goes this way

i've few detail sections then the sub report is inserted in a detail section followed by few detail sections, the issue here is when i check preview the report detail sections are displayed perfectly when comes to question of sub report its display 2 records repeatedly for pages together(approx 5 pages) and at the 5th page its dispalying all the records perfectly, later the same pages are repeated again.

i'm using the same stored procedure in both the main and sub report.

if some one has come across this sort of issue plz let me know how to overcome, i will be happy to explain you the problem in detail if some one is interested.

Thanks in advance

Murali..

mylogics22-Sep-09 20:27

mylogics

22-Sep-09 20:27

hii...
all.I m using asp.net 3.5.I have a feedback form.On the click of button i want to send mail.how can i do this.
can anybody send me a gud link which is self explanatory.
thanks....

Re: email

Ravi Mori22-Sep-09 20:35

Ravi Mori

22-Sep-09 20:35

hi..
If you search this thing in google, within a minute you will get link yourself because its a common task.

Anyway following is the link:

http://www.codedigest.com/Articles/ASPNET/95_Sending_Email_using_C__and_ASPNet_20.aspx[^]

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.