|
kavinnagarajan wrote: I have to change the color of the text when i send the mail.
Create HTML Text for that. Whatever formatting you want, do it in HTML. Set the Message Type Property IsHTML [ NOT Text] . Set the HTML Text as Message Body.
|
|
|
|
|
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.
|
|
|
|
|
You are retriving HTML Text from database ? What is the Field type ? It should be nvarchar(max). You want to show the same formatted text in the Multiline textbox ?
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
|
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..
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
How to send mail that contains data from sql database that should be attached to body. Please anyone help me now.
|
|
|
|
|
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();
try
{
SmtpClient Objsmtp = new SmtpClient();
Objsmtp .Host = "myMailServer";
Objsmtp .Send(Mail);
}
catch (Exception ex)
{
}
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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 -!
|
|
|
|
|
Use IFrame instead of DIV.
|
|
|
|
|
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
|
|
|
|
|
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...
modified on Saturday, August 8, 2009 1:07 AM
|
|
|
|
|
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.
|
|
|
|
|
i tried that but i hav no gud idea for serializable.. can you post code snippet for that??
thanks..
|
|
|
|
|
punit_belani wrote: i hav no gud idea for serializable
What is wrong in checking MSDN documentation?
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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,
|
|
|
|