|
|
hello all
How do we convert a data from database into XMLfile using asp.net with vb.net
i dont now such idea plzz send code also.
|
|
|
|
|
You can use DataSet[^] to load your database and after that you can call DataSet.WriteXml[^] method.
vbmadhavi wrote: plzz send code also.
Writing your code is your responsibility. Just search for DataSet tutorials, you will find lots of information. 
I hope this helps.
|
|
|
|
|
use Query From database Which gives to XML String.
For Example:
Select * from emp "Emplyee" FOR XML Auto
Which gives out put like
<Emplyee empid="11" ename="rajan" sal="1.200000000000000e+004" ephone="5654645" eAddress="baneshwor" />
<Emplyee empid="12" ename="pravakar" sal="2.500000000000000e+004" ephone="5654645" eAddress="shantinangar" />
<Emplyee empid="13" ename="nilu" sal="2.500000000000000e+004" ephone="5654645" eAddress="ghattekkulo" />
<Emplyee empid="14" ename="shekhar" sal="2.500000000000000e+004" ephone="5654645" eAddress="ekantakuna" />
<Emplyee empid="15" ename="sunil" sal="2.500000000000000e+004" ephone="5654645" eAddress="budanilakantha" />
<Emplyee empid="16" ename="Nilubhai" sal="2.000000000000000e+003" ephone="123456" eAddress="Kathmandu" />
|
|
|
|
|
You probably have to post this message to OP, too.
Your suggestion is good in case we want to save only data as XML.
But if we want to save entire database, including schema information except data, then DataSet.WriteXml method is very handy.
Regards
|
|
|
|
|
Hi...
I am newbie to asp.
my code is,
<asp:Button ID="LOGIN" Text="Submit" Height = "25px" Width = "78px"
runat="server" onclick="LOGIN_Click" ></asp:Button>
<br />
<%if (Login_Result == "1")
{
}
else
{
Response.Write(Login_Result);
} %>
</p>
when i click login button it will check in the database by c# code.
if its true means Login_Result will return "1". Otherwise it will return "0".
if Login_Result is "1", I have call call a new form main.aspx. How to do this?
Help me...G.Paulraj
|
|
|
|
|
Response.Redirect("main.aspx"); is one way: there are others.Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
what about code behind?
Is it in c# or vb?
If its c# , then
why don't you write your code on the on click event?
|
|
|
|
|
You should check the original post
Paulraj G wrote: it will check in the database by c# code.
LokeshZende wrote: If its c# , then
why don't you write your code on the on click event?
So you can't use code-behind with VB.NET?
You have done nothing to answer the OPs question.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
I have a checkbox in a datagrid and when i check the items and press addbutton i need to add all the checked rows value into hidden field.the add button calls the function readData() on client side.
the code was working fine with IE but it was not woking with mozilla
function ReadData() {
var grdContacts = document.getElementById('grdContacts');
var hiddenContacts = document.getElementById('hiddenContacts');
var rowCount = grdContacts.rows.length;
if(rowCount > 1)
{
var count =1;
for(; count < rowcount ; count++)
{
if(grdContacts.rows[count].cells[0].childNodes[0].childNodes[0].checked == true)
{ hiddenContacts.value += grdContacts.rows[count].cells[2].innerText + ";"; }
}
}
|
|
|
|
|
You can try with innerHTML
It should work in all the browserBest Regards,
Chetan Patel
|
|
|
|
|
I need to first find my check box and if the check box is checked then i need to get the InnerText.
I got the solution for the above.
Modified the function as below.
function ReadData()
{
var grdContacts = document.getElementById('grdContacts');
var hiddenContacts = document.getElementById('hiddenContacts');
var rowCount = grdContacts.rows.length;
if(rowCount > 1)
{
var browserName=navigator.appName;
for(var count =1; count
|
|
|
|
|
I have developed one internal web application having login credentials page with images.
main problem is that, the images are not loaded in login page. after login, in other page the same images are loading. i used I.E 8.and Firefox3. in both browsers not loaded the images.
we are using skinid.
below code is written like this
<asp:image runat="server" imageurl="~/App_Themes/Default/Images/myimage_beta.png" skinid="HeaderImage">;
Thanks in advance..
|
|
|
|
|
If u want to load before login into the application means, first check the web.config file has the '<deny>' property. To resolve this u must include <allow> property for the corresponding page(that is, if u load the images only after login means the .css file load successfully only after getting the credentials ). Try this! It may useful!
|
|
|
|
|
problem has resolved......
I have changed authentication security for integrated windows authentication check box checked in IIS settings
Thanks for your reply.
|
|
|
|
|
It might be you have used Forms Authentication in your application.
Put another Web.config file in your Images folder and remove the Authentication from that file.
|
|
|
|
|
hello everybody.
i want to insert the data into xmlfile.how it possible.
i developed code for this .but i dont know whether it is correct or not.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' Create xml dom
Dim XMLDom As New XmlDocument()
'this xml file is already i created.
XMLDom.Load("D:\XMLFILE1.xml")
'Selecting the main node
Dim newXMLNode As XmlNode = XMLDom.SelectSingleNode("persons")
'''''''get the node where i want to insert the data
Dim childNode As XmlNode = XMLDom.CreateNode(XmlNodeType.Element, "p", "")
''''''''In the below step "p" is my node name and "sree" is my data to insert
Dim newAttribute As XmlAttribute = XMLDom.CreateAttribute("p", "sree", "")
childNode.Attributes.Append(newAttribute)
newXMLNode.AppendChild(childNode)
end sub
when i run this code error occured i.e
Object reference not set to an instance of an object.
this error is occured in newXMLNode.AppendChild(childNode)
|
|
|
|
|
|
hello everybody.
i want to insert the data into xmlfile.how it possible.
i developed code for this .but i dont know whether it is correct or not.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' Create xml dom
Dim XMLDom As New XmlDocument()
'this xml file is already i created.
XMLDom.Load("D:\XMLFILE1.xml")
'Selecting the main node
Dim newXMLNode As XmlNode = XMLDom.SelectSingleNode("persons")
'''''''get the node where i want to insert the data
Dim childNode As XmlNode = XMLDom.CreateNode(XmlNodeType.Element, "p", "")
''''''''In the below step "p" is my node name and "sree" is my data to insert
Dim newAttribute As XmlAttribute = XMLDom.CreateAttribute("p", "sree", "")
childNode.Attributes.Append(newAttribute)
newXMLNode.AppendChild(childNode)
end sub
when i run this code error occured i.e
Object reference not set to an instance of an object.
this error is occured in newXMLNode.AppendChild(childNode)modified on Thursday, February 25, 2010 2:09 AM
|
|
|
|
|
Hi,
Check "newXMLNode" is null or not.
Thanks
Prosanta
|
|
|
|
|
hi
I am entering some text in div at run time. I want if a website url is entered then it should be clickable and redirect to that site just like in chatting window.
Please Help.
Thanks in advance.![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi
Check the text is a valid url with regular expression, if valid then render the text with "<a href='textvalue'>textvalue</a>' tag.
Cheers
Prosanta
|
|
|
|
|
I am entering text in div on button click at runtime just like chat window when user click on send button the text is entered into div. In that case how to do this?
|
|
|
|
|
you will have to do the same thing that Prosanta already said...search for text that could be links and make them into links. Here is a sample that shows how to do this: http://benalman.com/code/test/js-linkify/[^]
|
|
|
|
|
Hi, you can refer to the following code:
private void Button1_Click(object sender, System.EventArgs e)
{
string strContent = InputTextBox.Text;// <---the input text
Regex urlregex = new Regex(@"(http:\/\/([\w.]+\/?)\S*)", // <--check if url
RegexOptions.IgnoreCase| RegexOptions.Compiled);
strContent = urlregex.Replace(strContent,
"<a href=\"\" target=\"_blank\"></a>"); // <-- set display like a link
Regex emailregex = new Regex(@"([a-zA-Z_0-9.-]+\@[a-zA-Z_0-9.-]+\.\w+)",
RegexOptions.IgnoreCase| RegexOptions.Compiled);
strContent = emailregex.Replace(strContent, "<a href=mailto:></a>");
lbContent.Text += "<br>"+strContent;
}
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 8:46am.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
