ASP.NET

Re: Sentence colouring in Mail

7-Aug-09 21:06

Acutually i have to collect school student information. I have to get House address & contact no , Father name etc.........
To get house address of the student i used textbox, and its Textmode is Multiline. I can able to store house address in to database, where column name is "Address" and Datatype is "varchar(Max)".
But when i try to retrive the same house address from database in to same textbox i can't retrive it.

Abhijit Jana7-Aug-09 21:28

Abhijit Jana

7-Aug-09 21:28

How did you entered the data into database ? Append and <pre> + address.Text + </pre> with your text. And set the DB field as Nvarchar(Max).

Your text should be like

string StrAddress="<pre>" + txtAddress.Text "</pre>";

now insert StrAddress to DB. Then try to retreive it. Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

[Message Deleted]

kavinnagarajan7-Aug-09 19:43

Re: Multiline Textbox with Home address

7-Aug-09 19:43

[Message Deleted]

mylogics7-Aug-09 20:13

mylogics

7-Aug-09 20:13

kavinnagarajan wrote:
Hai,

I changed textmode of the textbox as Multiline and when i entered house address it stored in sql database. Datatype is varchar(Max). But when i try to retrive, i cant do. Please anyone help me for this question now.

hiii
r u trying to view the data in multiline textbox wat exactly
do u want..

Re: Multiline Textbox with Home address

N a v a n e e t h7-Aug-09 20:24

Textbox with Home address

7-Aug-09 20:24

kavinnagarajan wrote:
Please anyone help me for this question now.

I don't think someone will help you until you explain your problem clearly. Your question makes no sense.

Navaneeth

How to use google | Ask smart questions

kavinnagarajan7-Aug-09 20:24

Re: Textbox with Home address

7-Aug-09 20:24

Thanks for reply,

Actually i need to store and retrive house address from sql server. For getting address i used textbox with textmode as Multiline. I can able to insert the house address in to database with coulumn name as Address, datatype as varchar(Max). When i try to retrive the same address in to same textbox with textmode as Multiline i can't get it for the purpose of Address editing or Updating the address.

N a v a n e e t h7-Aug-09 20:28

Textbox with Home address

7-Aug-09 20:28

kavinnagarajan wrote:
When i try to retrive the same address in to same textbox with textmode as Multiline i can't get it for the purpose of Address editing or Updating the address.

Well, this also makes no sense. What do you mean by can't get it for the purpose of address editing? Are you not able to set the text to text box? Are you getting any error? What code have you used?

Please be more clear if you are expecting help.

Navaneeth

How to use google | Ask smart questions

kavinnagarajan7-Aug-09 20:38

7-Aug-09 20:38

i have store address in to database for that i used textbox with Multiline Property for getting address.
I can be able to store data or address in the textbox in to databse.
But when i try to retrive address from the database i can't retrive it in to same textbox.
But i can retrive other data from databse.
Exactly i can't retrive the address.

Mail

kavinnagarajan7-Aug-09 19:35

how to reduce downloading time video file

7-Aug-09 19:35

How to send mail that contains data from sql database that should be attached to body. Please anyone help me now.

Re: Mail

Abhijit Jana7-Aug-09 20:01

Abhijit Jana

7-Aug-09 20:01

Just Read the data from DB and set it as MailMessage.Body Property.

You have to use Following namespace,

Using System.Net.Mail

Sample Code :

MailMessage Mail = new MailMessage();
        MailAddress mailAdd = new MailAddress(txtFrom.Text,txtName.Text);
        Mail.From = mailAdd ;
        Mail.To.Add(txtTo.Text);
        Mail.Subject = txtSubject.Text;
        Mail.Body = ReadMailBody(); // Read data from Database
       try
        {
            SmtpClient Objsmtp = new SmtpClient();
	    Objsmtp .Host = "myMailServer"; 
            Objsmtp .Send(Mail);
          
        }
        catch (Exception ex)
        {
            //Handel Exception
        }

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

reogeo20087-Aug-09 19:05

reogeo2008

7-Aug-09 19:05

Dear all,

I have a gridview which contains number of video links listed down.when the user click on of the link it shuld display the coresponding video.my video is opeing and playing in real player.the problem is that it takes mych time to download video..how can i avoid the downloading time to make it fast..

Thanks in advance for any help

Re: how to reduce downloading time video file

N a v a n e e t h7-Aug-09 19:18

include file in aspx page from codebehind file.

7-Aug-09 19:18

reogeo2008 wrote:
how can i avoid the downloading time to make it fast..

ASP.NET has no control over this. You probably should read more about ASP.NET and the type of problems it can solve.

Navaneeth

How to use google | Ask smart questions

adkalavadia7-Aug-09 18:59

adkalavadia

7-Aug-09 18:59

hi....

i m going to make assembler page. In this page i want to read url on page load method and as per parameter.

ex. if URL is

http://mysite/assembler.aspx?pgname=aboutas

then "aboutus.aspx" page will be load on assembler page's div tag.

how can i include "aboutus.aspx" page through code behind file at assembler.aspx pages div?

thnks in advance.

!- F - R - I - E - N - D - S -!

Re: include file in aspx page from codebehind file.

r a m e s h7-Aug-09 19:15

r a m e s h

7-Aug-09 19:15

Use IFrame instead of DIV.

Re: include file in aspx page from codebehind file.

N a v a n e e t h7-Aug-09 19:16

convert database to xml file (but i want column as attribute) [modified]

7-Aug-09 19:16

AFAIK, there is no way to load an ASPX page. Why don't you redirect to aboutus.aspx when the criteria matches? Another method is to create make aboutus as a web user control. Put a place holder inside the DIV tag and load the appropriate control to it depending on the condition.

You need to use the LoadControl method for doing this. Something like,

Control c = LoadControl("aboutus.ascx");<br />
placeHolderId.Controls.Add(c);

Hope that helps Smile | :)

Navaneeth

How to use google | Ask smart questions

Punit Belani7-Aug-09 18:00

Punit Belani

7-Aug-09 18:00

hi.. i already convert database table to xml but it create new element for each column but i want each column as attribute..

code i have is as below:

public partial class Default2 : System.Web.UI.Page
{
      protected void Page_Load(object sender, EventArgs e)
      {
            DataSet ds = GetDataSet();
            myXMLControl.DocumentContent = ds.GetXml();

      }
      public DataSet GetDataSet()
      {
            DataSet result = new DataSet();
            string connString
                  = "server=192.0.0.1;user id=test;password=123;persist security info=True;database=MLM1";
            using (MySqlConnection myConnection = new MySqlConnection(connString))
            {
                  string query
                        = "Select userid,code,parent_id from _relation";
                  MySqlCommand myCommand = new MySqlCommand(query, myConnection);
                  MySqlDataAdapter myAdapter = new MySqlDataAdapter();
                  myCommand.CommandType = CommandType.Text;
                  myAdapter.SelectCommand = myCommand;
                  myAdapter.Fill(result);
                  myAdapter.Dispose();
            }

            result.DataSetName = "root";
            result.Tables[0].TableName = "Node";
            DataRelation relation = new DataRelation("ParentChild",//tab.Columns.Add("userid"),tab.Columns.Add("parent_id"),true);
                        result.Tables["Node"].Columns["userid"],
                        result.Tables["Node"].Columns["parent_id"]);

            relation.Nested = true;
            result.Relations.Add(relation);

            result.WriteXml(@"C:\punit\vs2008\Copy of prac\demo.xml");
            return result;

      }
}

and i get xml file converted as:

<?xml version="1.0" standalone="yes"?>
<root>
   <Node>
      <userid>1</userid>
      <code>1VXZ0709</code>
      <parent_id>0</parent_id>
      <Node>
         <userid>2</userid>
         <code>2PJB0709</code>
         <parent_id>1</parent_id>
      </Node>
   </Node>
</root>

but iwant result as below:
<?xml version="1.0" standalone="yes"?>

   <Node userid="1" code="1VXZ0709" parent_id="0">
      <Node userid="2" code="2PJB0709" parent_id="1">
      </Node>
   </Node>

thanks in advance....
regards... Smile | :)

modified on Saturday, August 8, 2009 1:07 AM

Re: convert database to xml file (but i want column as attribute)

N a v a n e e t h7-Aug-09 18:43

Re: convert database to xml file (but i want column as attribute)

7-Aug-09 18:43

DataSet provides limited options to extend the XML writing behavior.

To create a custom XML format like you mentioned, you may need to create your own serializable type and add proper attributes to it. You can use XmlSerializer[^] to serialize this into a stream or file.

Navaneeth

How to use google | Ask smart questions

Punit Belani7-Aug-09 18:51

Punit Belani

7-Aug-09 18:51

i tried that but i hav no gud idea for serializable.. can you post code snippet for that??
thanks..

Re: convert database to xml file (but i want column as attribute)

N a v a n e e t h7-Aug-09 19:09

Custom /efficient paging and sorting gridview

7-Aug-09 19:09

punit_belani wrote:
i hav no gud idea for serializable

What is wrong in checking MSDN documentation? D'Oh! | :doh:

Any way here is a sample,

using System.Xml;
using System.Xml.Serialization;
using System.IO;

[Serializable]
public class Person
{
    [XmlAttribute("Name")]
    public string Name { get; set; }

    [XmlElement]
    public int Age { get; set; }
}

Person person = new Person()
{
    Name = "Chuck norris",
    Age = 40
};

using (FileStream fs = new FileStream("person.xml", FileMode.Create, FileAccess.Write))
{
    XmlSerializer serializer = new XmlSerializer(typeof(Person));
    serializer.Serialize(fs, person);
}

The attributes on each property tells the XmlSerializer object about the way it should produce output XML.

Smile | :)

Navaneeth

How to use google | Ask smart questions

mark_me7-Aug-09 17:33

mark_me

7-Aug-09 17:33

Hi,
Sorry, if this question is stupid but i have tried searching alot and couldn't find an exact answer. Also, i am not looking for an exact solution but guidance in the right direction would be highly appreciated.

I realize that gridview paging selects all data but displays a portion of it. I want to implement custom paging where data is only specific data is selected. I have kind of done my homework on it. ie i can use linq to select and skip data, but i want page links to be displayed at the bottom of the page. Is there any property that sets this (i believe datagrid had virtualitemcount). Does gridview has something like this or do i need to program this portion. I would like to mention here that i don't want to use SqlDataSource or ObjectDataSource, rather i want to assign datatable to gridview.DataSource. Again, would i have to manage paging my self, if i implement above solution.

Sorry, if its a stupid question. Again i found solutions on google but none had numbered pages in bottom of gridview, which i want to have. I can do it with next,prev btn at the moment.

Thankyou very much

N a v a n e e t h7-Aug-09 17:59

7-Aug-09 17:59

mark_me wrote:
i can use linq to select and skip data

I don't know anything about the problem domain you are working on and data structures you use. But if database is your persisting area, efficient way to do this is to get only rows that will be displayed.

mark_me wrote:
Again i found solutions on google but none had numbered pages in bottom of gridview, which i want to have. I can do it with next,prev btn at the moment.

IMO, there is nothing wrong in using ObjectDataSource since it comes with inbuilt paging capabilities. If you are binding a DataTable, you need to set the TypeName property to DataTable.

You need to provide two methods, one for selecting the data according to the page number and another method for calculating the total count of data. These methods should be assigned to SelectMethod and SelectCountMethod properties respectively.

Scott Guthrie's article[^] gives an overview of doing this. He is using ASP.NET AJAX but the concepts are same.

Smile | :)

Navaneeth

How to use google | Ask smart questions

mark_me7-Aug-09 18:19

mark_me

7-Aug-09 18:19

Thankyou very much Navaneeth!
I looked into the link that u have forwarded and seems like its the solution i was looking for. Thankyou.

Actually, to be honest, i don't know why i didn't use sqldatasource. Probably, because i thought that maybe i will require a sqldatasource for each page and thought its better that i make one procedure and pass column names along with whereCondition and table name , and then use datasource=mytable. Though, initially it seemed a good idea but now i realize that probably, it was a bad idea. Anyways, I can get count of rows, but my problem is page links ie 1 2 3 4 ... at the bottom, Do i have to implement it manually or is there any property that would help me in a few lines of code.

Thankyou,

N a v a n e e t h7-Aug-09 18:30

7-Aug-09 18:30

mark_me wrote:
i don't know why i didn't use sqldatasource

I was recommending ObjectDataSource not SqlDataSource. In fact, SqlDataSource is crap and should only be used for demonstration purpose.

mark_me wrote:
, Do i have to implement it manually or is there any property that would help me in a few lines of code.

You don't have to implement it. See the article which I linked, he hasn't wrote extra code to display page numbers.

Glad to hear that it helped. Smile | :)

Navaneeth

How to use google | Ask smart questions