C# Discussion Boards - CodeProject

Christian Graus21-May-08 0:31

21-May-08 0:31

Look[^] what I found with google !!!

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Le centriste21-May-08 1:54

Le centriste

21-May-08 1:54

I suggest that Chris implements a functionality where every time a new post is made on aprogramming forum there is an automatic reply telling the poster to do a search on Google.

originSH21-May-08 0:32

originSH

21-May-08 0:32

http://www.connectionstrings.com/[^]

You want to use the OLEDB provider.

csetopper_bhanu21-May-08 0:38

csetopper_bhanu

21-May-08 0:38

yes .. i would like to use OLEDB data provider

csetopper_bhanu

csetopper_bhanu21-May-08 1:28

csetopper_bhanu

21-May-08 1:28

Thanx dude

csetopper_bhanu

[Message Deleted]

venkat86_ece20-May-08 23:48

venkat86_ece

20-May-08 23:48

[Message Deleted]

Gareth H20-May-08 23:59

Gareth H

20-May-08 23:59

venkat86_ece,

This tells you how[^]

Regards,
Gareth.

(FKA gareth111)

originSH21-May-08 0:00

originSH

21-May-08 0:00

Learn a programming language, learn the associated libraries and frameworks, design the application and then make the application.

Christian Graus21-May-08 0:00

21-May-08 0:00

I guess you write some code that contains all the items that need to go in the time table, then somehow works out a way to organise those items so they don't clash.

If this is homework, then we would not be helping you if we did it for you. If this is paid work, why should you get paid if you're incapable of doing the work on the most basic level ? Come back when you've tried to do this yourself, and we'd love to offer more specific help.

Spunky Coder21-May-08 0:11

Spunky Coder

21-May-08 0:11

I think it's an home work..I can tell that from his name venkat86_ece ..now 86 could be his year of birth and ece is actually Electronics and communication engineering (in India)..so based on his current location (US) he is probably doing M.S in US and so its an home work.

Wow..Wow..i've got detective skills Sherlock Holmes or JamesBond Big Grin | :-D

$Shucks | :-\$

For all this research it means I've got no work at my office Smile | :)

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

J4amieC21-May-08 1:10

J4amieC

21-May-08 1:10

James Bond is a spy, not a detective. So to qualify you would have to bug him and stealthily observe him doing his ECE.

Export to Excel File Size Issue

MumbleB21-May-08 2:21

MumbleB

21-May-08 2:21

What is up with all the deleted posts? Maybe "James Bond" can figure that out??

Laugh | :laugh:

Excellence is doing ordinary things extraordinarily well.

rrprabu20-May-08 23:30

rrprabu

20-May-08 23:30

Hi,
I am writing a code in c# with asp.net 2003 for export to excel from Repeater Control.In this I am facing file size is very big than normal.It has 5000 rows also 120 Columns.In these around 60 Columns are containing text class(style Sheet).I got exported file size is 32 MB.But if I copy those rows from exported file and paste it into new file , the new file has only 5.2 MB.Even If i open the exported file and save as new copy ,Its also contains 5.2 MB only. How to Reduce my file size while exporting only.My code is

<br />
        string strFilePath="";<br />
	DateTime tTime = DateTime.Now;<br />
	strFilePath =  "ADSL"+tTime + ".xls";<br />
	strFilePath = strFilePath.Replace("/","");<br />
	strFilePath = strFilePath.Replace(" ","");<br />
	strFilePath = strFilePath.Replace(":","");<br />
	string serverpath = Request.PhysicalApplicationPath.ToString();<br />
	serverpath += @"ExcelFiles\";<br />
	if (!Directory.Exists(serverpath))<br />
	{<br />
		Directory.CreateDirectory(serverpath);<br />
	}<br />
	serverpath += strFilePath;<br />
	string style = @"<style> .text { mso-number-format:\@; } </style> ";<br />
	Repeater1.Items[0].Visible = true;<br />
	Response.Clear(); <br />
	Response.AddHeader("content-disposition", "attachment;filename=" +serverpath);<br />
	Response.ContentType = "application/vnd.ms-excel";<br />
	System.IO.StringWriter stringWrite = new System.IO.StringWriter();<br />
	System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);<br />
	Repeater1.RenderControl(htmlWrite);<br />
	Response.Write(style);<br />
	Response.Write(stringWrite.ToString());<br />
	Response.End();<br />

If anyone knows answers, Plz reply fast.This is urgent

Regards
prabu

StringBuilder ' escape sequence

StyleGuide20-May-08 22:44

StyleGuide

20-May-08 22:44

Hi there,

Can anyone suggest the best way, or point me in the direction of, escaping or qualifying an ' (apostrophe) character within a StringBuilder?

Unsurprisingly, I get a 'Missing operand after' error with the following:

sb = "LastName = 'O'Brien'"

Thanks

Jon

Bekjong20-May-08 23:05

Bekjong

20-May-08 23:05

StringBuilder sb = new StringBuilder(@"LastName = 'O'Brien'");

Standards are great! Everybody should have one!

StyleGuide20-May-08 23:48

StyleGuide

20-May-08 23:48

Thanks for this Bekjong,

Sorry - I forgot to say I am getting the error on this line:

namesBindingSource.Filter = sb.ToString();

Thanks

Jon

Vikram A Punathambekar21-May-08 0:07

Vikram A Punathambekar

21-May-08 0:07

In SQL, you have to prefix single quotes with single quotes.

yourQuery = "SELECT * FROM Grades WHERE StudentName = 'Scarlett O ''Hara'"

Cheers,
Vikram.

The hands that help are holier than the lips that pray.

dan!sh 21-May-08 0:07

dan!sh

21-May-08 0:07

Following code gives me no error Confused | :confused:

BindingSource o = new BindingSource();<br />
StringBuilder s = new StringBuilder("LastName = 'O'Brien'", 50);<br />
o.Filter = s.ToString();

Am I missing something?

Avoid Google. Use Blackle[^]

change text in .rtf file using c# code

StyleGuide21-May-08 0:19

StyleGuide

21-May-08 0:19

Thanks Vikram, d@nish,

Thanks for the tip Vikram.

d@anish - Yes you're right, however I get the error when applied to my namesBindingSource

Thanks

Jon

kamalesh574320-May-08 22:41

kamalesh5743

20-May-08 22:41

Hi all,
I need change text in external .rtf file using c# code..
thank you..

%#&kmpYrlHSGYG5@#($_+!@!(*JASnjshdk,cm_0ashjhdbn@#$!48mkhfbchsh))^%#W%&@YW7wsdfjw789';'][]\`~JKJQ4$!@#~)-HSKS^&*1)JK12@#@$~!1`DFGkqp][]\]?Zas;EWRG%!@~)(^&BVAG

Re: change text in .rtf file using c# code

Christian Graus20-May-08 23:23

Active Accessibility thru c# / Getting FIrefox URL

20-May-08 23:23

Seems like you've been asking this for days. I suspect that putting it into a rich text box is the easiest way to change it and keep it in RTF format. Otherwise you need to get another RTF parser, or write one.

mihir raut20-May-08 21:35

mihir raut

20-May-08 21:35

Good afternoon.
I have been tasked with "scraping" the URL from a firefox browser from our C# program. The issue I ran into is that the Address bar in Firefox is not accessible.
Can any body help me in this

Thank you for your time on this matter,

Mihir

Help Needed With Popup

sanchit_mum0720-May-08 21:33

sanchit_mum07

20-May-08 21:33

hi all,

on my aspx page which is a child page of a master page.
i have a textbox say "TextBox1" with that i have one button say "Button1"

now on ClientClick on Button1 i want to open a popup which will have some list box say "LSt1" and a button say "OK"

as user selects some option from lst1 and clicks on Ok then those selected values should come in Textbox1 without any page refresh.

I am able to do this all but only the problem is my base page is postbacking itself.

A glimpse of code i m trying to use:

main aspx page>>>>

function OpenNewPopUpWindow(Url)
{
var Attributes='width=400,height=300,left=200,top=200,location=no,directories=no,status=yes,menubar=no,scrollbars=yes,copyhistory=yes, resizable=no';
window.open(Url,"PoPup",Attributes);

}

asp:Button ID="btntxtFindingsComments" runat="server" CausesValidation="False" Text="..."/>

main aspx.cs page>>
btntxtFindingsComments.Attributes.Add("onClick", "javascript:OpenNewPopUpWindow('PoPup.aspx?Id=" + txtFindings.ClientID + "&CommentId=901');");

Popup.aspx>>

function LoadValues(clientCtrl, selectedValue)
{
window.opener.document.getElementById(clientCtrl).value = selectedValue;
self.close();
}

<asp:listbox id="lstTIPComments" runat="server" appenddatabounditems="false">

<asp:button id="Button1" runat="server" text="Close" onclick="Button1_Click">

popup.aspx.cs>>
protected void Button1_Click(object sender, EventArgs e)
{
string selectedValue = "";
for (int i = 0; i < lstTIPComments.Items.Count; i++)
{
if (lstTIPComments.Items[i].Selected == true)
{
selectedValue = " " + selectedValue + lstTIPComments.Items[i].Text + " ";
}
}

Page.ClientScript.RegisterStartupScript(this.GetType(), "close", "LoadValues('" + Request.QueryString["Id"].ToString() + "','" + selectedValue + "');");

}

Re: Help Needed With Popup

Christian Graus20-May-08 22:02