|
Hi Every body...,
i have problem with CSV.How to Coverting data in a table to CSV file.
(i am using Sql2005 and Vs2005 asp.net ajax,C#)
Please Help Me.........,
|
|
|
|
|
The fact that you mention AJAX makes me worry that you don't understand any of hte things you are using.
you get your data from SQL Server, and you write it to a file, with a comma between each value and a new line between each line. It's really that simple. Which bit are you stuck on ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
1) Using a datareader to directly read the data and write the file yourself
2) Using a DataTable/DataAdapter combination to load the data and write the file yourself
3) Using Sql's built-in export feature to write the file
4) Using Sql's ability to output Xml and using an XSL Transformation to write the file
There, that should give you some google fodder.
Ive probably missed a few.
|
|
|
|
|
Hi,
I m trying to retrieve address book of hotmail using the api.
I m getting error 404.
Can any one help me out with this?
here is my class file
public class LiveExtract : IMailContactExtract
{
#region IMailContactExtract Members
public bool Extract( NetworkCredential credential, out MailContactList list )
{
list = new MailContactList();
bool result = false;
try
{
TicketAcquirer ticketAcquirer = new TicketAcquirer();
string ticket = ticketAcquirer.GetTicket( credential );
if ( string.IsNullOrEmpty( ticket ) )
{
return false;
}
UriBuilder urib = new UriBuilder();
urib.Scheme = "HTTPS";
urib.Path = string.Format( "/{0}/LiveContacts", credential.UserName );
urib.Host = "cumulus.services.live.com";
//urib.Host = "hotmail.com";
//urib.Host = "login.live.com/login.srf?wa=wsignin1.0&rpsnv=10&ct=1235053953&rver=5.5.4177.0&wp=MBI&wreply=http://mail.live.com/default.aspx&lc=1033&id=64855&mkt=en-US";
urib.Port = 443;
HttpWebRequest request = ( HttpWebRequest ) WebRequest.Create( urib.Uri );
string authHeader = string.Format( "WLID1.0 t=\"{0}\"", ticket );
request.Headers.Add( "Authorization", authHeader );
WebResponse response = request.GetResponse();
if ( response.ContentLength != 0 )
{
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.Load( response.GetResponseStream() );
XmlNodeList contacts = xmlDocument.SelectNodes( "/LiveContacts/Contacts/Contact" );
foreach ( XmlNode node in contacts )
{
//XmlNode firstName = node.SelectSingleNode( "Profiles/Personal/FirstName" );
//XmlNode lastName = node.SelectSingleNode( "Profiles/Personal/LastName" );
//XmlNode firstMail = node.SelectSingleNode( "Emails/Email/Address" );
//MailContact mailContact = new MailContact();
//mailContact.Name = string.Format( "{0} {1}", firstName.InnerText, lastName.InnerText );
//mailContact.Email = firstMail.InnerText;
//list.Add( mailContact );
string firstName = node.SelectSingleNode("Profiles/Personal/FirstName") != null ? node.SelectSingleNode("Profiles/Personal/FirstName").InnerText : null;
string lastName = node.SelectSingleNode("Profiles/Personal/LastName") != null ? node.SelectSingleNode("Profiles/Personal/LastName").InnerText : null;
string email = node.SelectSingleNode("Emails/Email/Address") != null ? node.SelectSingleNode("Emails/Email/Address").InnerText : null;
if (!string.IsNullOrEmpty(email))
{
MailContact mailContact = new MailContact();
mailContact.Name = string.Format("{0} {1}", firstName, lastName);
mailContact.Email = email;
list.Add(mailContact);
}
}
}
result = true;
}
catch
{
}
return result;
}
#endregion
}
Vijay V.
Yash Softech
|
|
|
|
|
hi i am using following function to get date..
gmdtrdate.Text = DateTime.Today.Date.ToShortDateString();
it is returning me 2/2/2008
can i get it like 02/02/2008 or i will have to attach 0 manually???
umerumerumer
|
|
|
|
|
use
Response.Write(String.Format("{0:MM/dd/yyyy}", DateTime.Now()));
The miracle is this--the more we share, the more we have.
|
|
|
|
|
i dont want to hard code these values i just want to pick according to the regional date settings... if american then MM/dd/yyyy if british then dd/MM/yyyy
....
umerumerumer
|
|
|
|
|
I checked on mine, its returning 21-02-2009. And It depends on client regional settings.
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
am working in online application asp.net with c#..
i have to create dynamic pages...
that means i have to update day to day events...
how can i do this...
send me suggestions...
thanks in advance...
|
|
|
|
|
Follow these instruction. It may help you.
(1) Use database to save contents.
(2) Create admin panel to add/update contents.
(3) Create dynamic link from database for menu/user prospects.
Go ahead... It is very easy...
The miracle is this--the more we share, the more we have.
|
|
|
|
|
thx for ur rply it is usefull to me...
i follow that...
can u provide sample links..
|
|
|
|
|
|
i am searching...
but i could not find any use full link to my work yet...
|
|
|
|
|
Hello frnds,
I have a problem...
In my project we have to enter the user's credentials.eg.
Name
Father's name
Mother's name
After taking the credentials we have button "print".Whenever the user presses the button , A preview will be shown first.
And the preview will be on the word document.The word document is in the fixed format.eg.
Name
_____________
Father;s Name
______________
Mother's Name
_________________
So my problem is I am able to have....
Name
Father's Name
Mother's Name
and the desired o/p is
Name
_____________
Father;s Name
______________
Mother's Name
_________________
I am unable to read the line separation in the word document..
Please give me some guidance to do this....
cheers,
sneha
|
|
|
|
|
Hi i have public void method in my back end code part...,
In that i am getting some datas and binding into a table...,
Now my question is, i called the method on my aspx page itself, like this...,
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td id="E" align="center">
<%loadWatchlist(this, null);%>
</td>
</tr>
</table>
i know,can i call the method on my page load also,like this?,
If(!isPostBack)
{
loadWatchlist();
}
whats the difference between the two ways of call...,
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
Good Question...
In my view, there is no difference between them except 1st one is conventional ASP Style and next one is new .NET style.
The miracle is this--the more we share, the more we have.
|
|
|
|
|
Hi sir,
I want to embed flash player in asp.net web page and what tag are used.
sourabh
|
|
|
|
|
i think it's nothing diffirent to do it in normal html.
|
|
|
|
|
hello how can retrieve data in database
i want fill all the check box selected from database
use JavaScript asp.net
|
|
|
|
|
|
What you actually mean by checkbox,How you can store data in checkbox from database ,for what,do one thing, if you are using windows operating system(atleast u must aware of that) ,after switched on the computer wait for some time ,notice,something is happening there but dont do anything.Atlast u will get a screen that wont change.Stare at the left bottom side of the screen ,U can see a start ,Just press there with ur mouse cursor,u will then get some lists and u will see a picture of e and the name will be Internet Explorer.Click there ,one window will come type the url(u are able to reach at code project ,so i am guessing that u can do that)type www.google.com ,inside that type checkboxes and do search.If the google page is not comming and saying that This page cannot be displayed ,that means we are lucky(except u) or ur internet connection is lost.
|
|
|
|
|
JAS GIRI wrote: use JavaScript asp.net
Wow. Another day, and all you've done is find a new way to ask the same questions. Javascript can't see your database, why would you use it to fill checkboxes from your database ? You don't know, do you ? You stopped playing WoW today and in the toilet you found a magazine left there by real programmers, so you turned a few pages and learned a new buzzword. Sorry, you got it wrong. And, another day has gone by and you've still not done any work. How long before your boss notices ?
I see you posted some code in a seperate post. How about you post the bit of code that you wrote to do the bit you're trying to do, and explain what you've tried to make it work, what you're seeing in the debugger, and where you are confused. All the stuff that we'd see if we got asked a question from a programmer.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
SqlConnection cn = new SqlConnection(@"");
string []Sel=new string[3];
int Cnt;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("Select * from color", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "color");
string d;
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
for (int j = 1; j <= ds.Tables[0].Columns.Count-1; j++)
{
d = ds.Tables[0].Rows[i].ItemArray[j].ToString();
Sel = d.Split(new Char[] { ',' });
Cnt = Sel.Length;
switch (j)
{
case 1:
{
multchk(chk1, chk2, chk3, Sel);
break;
}
case 2:
{
multchk(chk4, chk5, chk6, Sel);
break;
}
}
}
}
}
protected void multchk(CheckBox ch1,CheckBox ch2,CheckBox ch3,string []str)
{
if (Cnt==1)
{
if (str[0] == "1")
ch1.Checked = true;
if (str[0] == "2")
ch2.Checked=true;
if (str[0] == "3")
ch3.Checked = true;
}
if (Cnt==2)
{
if (str[0] == "1" || str[1] == "1")
ch1.Checked = true;
if (str[0] == "2" || str[1] == "2")
ch2.Checked = true;
if (str[0] == "3" || str[1] == "3")
ch3.Checked = true;
}
if (Cnt==3)
{
if (str[0] == "1" || str[1] == "1" || str[2] == "1")
ch1.Checked = true;
if (str[0] == "1" || str[1] == "2" || str[2] == "3")
ch2.Checked = true;
if (str[0] == "1" || str[1] == "2" || str[2] == "3")
ch3.Checked = true;
}
}
protected void singchk(CheckBox ch1,CheckBox ch2,string []str)
{
if (str[0] == "1")
ch1.Checked = true;
if (str[1] == "2")
ch2.Checked = true;
}
|
|
|
|
|
This is the worst code I've seen in a long time. SO many things wrong with it. If someone I paid wrote this, I'd fire them. In fact, there's no way I'd have hired them.
Your checkboxes are called chk1, chk2, chk3, chk4, chk5, and chk6 ? Are you hoping for future outsourcing work on the basis that your code is unreadable ?
JAS GIRI wrote: string d;
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
for (int j = 1; j <= ds.Tables[0].Columns.Count-1; j++)
{
d = ds.Tables[0].Rows[i].ItemArray[j].ToString();
You create d outside the loop but only use it inside. you use <= x-1 instead of < x, you start j from 1 instead of 0 ( is that right ), you use i and j instead of meaningful names, what a mess.
JAS GIRI wrote: protected void multchk(CheckBox ch1,CheckBox ch2,CheckBox ch3,string []str)
{
if (Cnt==1)
{
if (str[0] == "1")
ch1.Checked = true;
if (str[0] == "2")
ch2.Checked=true;
if (str[0] == "3")
ch3.Checked = true;
}
if (Cnt==2)
{
if (str[0] == "1" || str[1] == "1")
ch1.Checked = true;
if (str[0] == "2" || str[1] == "2")
ch2.Checked = true;
if (str[0] == "3" || str[1] == "3")
ch3.Checked = true;
}
if (Cnt==3)
{
if (str[0] == "1" || str[1] == "1" || str[2] == "1")
ch1.Checked = true;
if (str[0] == "1" || str[1] == "2" || str[2] == "3")
ch2.Checked = true;
if (str[0] == "1" || str[1] == "2" || str[2] == "3")
ch3.Checked = true;
}
}
The logic surrounding Cnt is poorly implemented. Again, it's like you're trying to write spaghetti code.
Perhaps if you in one place posted your crappy code, some notes as to what you're trying to do, an explanation of the data you're using, why you can't use a checkboxlist, and what exactly this code does, as opposed to what you expect it to do, perhaps then someone who feels like doing your job for you, might have what they need in order to help. If you fail to do this in the next day, then I'd suggest you're beyond any sort of help, and should just give up.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Is there MS SQL database server in visual studio 2008? or we have to setup it separately?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
