How to Use Sql Transactions With DataRow ? - C# Discussion Boards

Re: Display Datagrid Decimal to 2 places

8-Dec-06 5:58

Why not display it as a string and use format?

jeweladdict8-Dec-06 6:49

jeweladdict

8-Dec-06 6:49

because the dataset is formatted as a decimal, and then the dataset is bound to the datagrid. Is there is a way to easily format the datagrid to show string.

Re: Display Datagrid Decimal to 2 places

ed^nrgc8-Dec-06 6:59

8-Dec-06 6:59

Change the DataBinder.Eval(Container.DataItem, "YourFieldName") to either a server side function or inline.

Need help with Regex

zaboboa8-Dec-06 5:08

zaboboa

8-Dec-06 5:08

Hello,

I have the following constants:

<br />
public static string DOCUMENT_NAME_PARSE_EXPRESSION = @"(AG_DOCNAME)(?innerDocName.*?)(AG_DOCNAME)";<br />
public static string DOCUMENT_NAME_INNER_EXPRESSION = @"${innerDocName}";<br />

I have the string that contains something like that:

..some text here .....AG_DOCNAMEtestAG_DOCNAME......some text here...

Now I pass that string into a function:

<br />
private bool ReplaceValueInHTML (string context, string newValue)<br />
{<br />
Regex expression = new Regex(DOCUMENT_NAME_PARSE_EXPRESSION, RegexOptions.IgnoreCase | RegexOptions.Multiline | RegexOptions.Singleline | RegexOptions.Compiled | RegexOptions.ExplicitCapture);<br />
<br />
Match match = expression.Match(context);<br />
if (match.Success)<br />
{<br />
    // WHAT GOES IN HERE               <br />
}<br />
else<br />
{<br />
    return false;<br />
}<br />
return true;<br />
} <br />

What I am trying to do is this: After I find that substring (AG_DOCNAMEtestAG_DOCNAME), I want to replace "test", with the newValue. And after user expression.Replace(context, match), or something like that. Proble is I can't replace that "test" value. Anybody has any ideas?

Thank you.

Re: Need help with Regex

ed^nrgc8-Dec-06 7:04

Insert javascript into IE Address bar

8-Dec-06 7:04

Use group patterns.

Example:

Regex regex = new Regex( @"\sFrom\:[\s]+\""(?<from>(.)+)\""\s+To\:[\s]+\""(?<to>(.)+)\""\s+Subject\:[\s]+(?<subject>(.)+)Date\ Frown | :(

s|\S)+\sBody\:[\s]+(?(.)+)\r\n");

Match match = regex.Match(message);

txtFrom.Text = match.Groups["from"].ToString();
txtTo.Text = match.Groups["to"].ToString();
txtSubject.Text = match.Groups["subject"].ToString();
txtBody.Text = match.Groups["body"].ToString();

PhrankBooth8-Dec-06 4:39

PhrankBooth

8-Dec-06 4:39

Hello,

I got a c# app that controls a website through mshtml. I'm trying to execute a javascript that for some reason will not execute through the standard:

IHTMLWindow2 win = HTMLDoc.parentWindow;
win.execScript(theScript, "JScript");

I have found that if I manually enter the jscript into the IE address bar and hit GO, then it will run.

However I have tried the Navigate and the window.open(js) and these do not work either.

Any clues out there as to how one would insert a jscript into the IE address bar and click go through c#?

Help appreciated, thanks in advance!

PhrankBooth

Re: Insert javascript into IE Address bar

ed^nrgc8-Dec-06 7:06

How to Use Sql Transactions With DataRow ?

8-Dec-06 7:06

have you tried RegisterClientScriptBlock?

hdv2128-Dec-06 4:17

hdv212

8-Dec-06 4:17

hi thanks for Reply me this Article that show how to use Transactions :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqltransactionclasstopic.asp[^]

but, does any body can show me how to use Sql Transactions in DataRow ?
i use datarow to add,update,delete Rows
thanks.

Re: How to Use Sql Transactions With DataRow ?

Colin Angus Mackay8-Dec-06 4:41

Colin Angus Mackay

8-Dec-06 4:41

You waited 6 hours 22 minutes and then you got sufficiently impatient that you posted again while your original post is still on the first page of the forum. We answer questions voluntarily so some patience would be nice.

hdv212 wrote:
does any body can show me how to use Sql Transactions in DataRow ?

SqlTransaction is for transacting multiple queries on a SQL Server not the DataRow.

Upcoming Scottish Developers events:
* We are starting a series of events in Glasgow in 2007. Are you interested in a particular subject, or as a speaker?
* Developer Day Scotland: are you interested in speaking or attending?

My: Website | Blog | Photos

Network Credentials for domain user

vineas8-Dec-06 4:15

vineas

8-Dec-06 4:15

There are several apps across our company that need to access a WebService that is really a SQL Server 2005 SOAP endpoint. A domain service account was created for it so we wouldn't have to enable access for every single user. Initially, this user was setup as being allowed to logon to the server that SQL Server 2005 was running on. However, when we tried to access it, nothing worked. After monkeying around for a few days, in order to make it work we finally had to enable this service account logon priviledges to the computer calling the webservice. It turned out we didn't even need logon priviledges to the server.

This seems completely backwards to everyone here, and will be a real pain to administer if it is the case.

Here's some code that's similar to what we're doing to access it:

private DataSet GetInformation()
{
	wsSQL service = new wsSQL();
	// no, my code doesn't have this hardcoded like this, it is merely for simplicity of the example. :)
	service.Credentials = new NetworkCredentials("user", "pass");
	
	return service.CallWebMethod();	
}

The above code works only if the "user" has logon access to the local computer. From the looks of how this works, it's almost as if the NetworkCredentials uses the local computer to log onto the network, then passes those credentials on. Is this correct? If so, is there anyway to use the domain user to logon to the server and use those credentials?

-----
In the land of the blind, the one eyed man is king.

Treeview and jump to node

Saamir8-Dec-06 4:13

Saamir

8-Dec-06 4:13

Hi Guys,
Question please, how do you skip to a particular node on the tree when the tree loads?

Thanks in advance.

sasa

Pete O'Hanlon8-Dec-06 5:01

Pete O'Hanlon

8-Dec-06 5:01

Have a guess. Go on... What do you think will select a particular node? Yup, it's SelectedNode Big Grin | :-D

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

Deja View - the feeling that you've seen this post before.

Not Active8-Dec-06 5:07

Not Active

8-Dec-06 5:07

What environment are you using? Windows, Web? You can't use Tree.SelectedNode = ???

only two letters away from being an asset

Saamir8-Dec-06 5:55

Saamir

8-Dec-06 5:55

I have tried this and it doesn't work for some weird reason, basically what I am doing is when a node is modified, e.g inactivated the imageindex is changed and hence I tried refreshing by reloading the tree to show the new image index, it does show the new imageindex but until I expand the tree and go to that node by clicking my way through. Basically, I want to reload the tree and jump back to the node where I was before the reload.

Please help!!!

sasa

Not Active8-Dec-06 6:05

Not Active

8-Dec-06 6:05

Well then, that's a bit different then just selecting a node. D'Oh! | :doh:

There is no way that I'm aware of to expand the tree down to the node in question without actually calling expand on the parents of that node.

only two letters away from being an asset

scrapbook - help

sanaziuse8-Dec-06 4:03

sanaziuse

8-Dec-06 4:03

hi all.
I want to write and create a scrapbook ( messageboard ) in C# ( asp.net) and my database is sqlserver 2000
I have problem in writing it. Can anyone help me and give me the code in C# ...?
I have created the table in database and the program is connected to database . I know I need to insert text(messsage) into database but how can I SHOW the posted message in the page...??
I want to show all the posts and the last post in the page...like here ...
please help me.
thanks alot.

Colin Angus Mackay8-Dec-06 4:36

Colin Angus Mackay

8-Dec-06 4:36

sanaziuse wrote:
I want to write and create a scrapbook ( messageboard ) in C# ( asp.net) and my database is sqlserver 2000
I have problem in writing it. Can anyone help me and give me the code in C# ...?
I have created the table in database and the program is connected to database . I know I need to insert text(messsage) into database but how can I SHOW the posted message in the page...??
I want to show all the posts and the last post in the page...like here ...

This is all far too vague - we don't know anything about the architecture of your application, the data model you are using etc. Your question is too general and so any meaningful answer would likely take many pages.

You have to be specific. What exactly do you need help with?

sanaziuse8-Dec-06 4:59

sanaziuse

8-Dec-06 4:59

hi.
I need the C#.net code for scrapbook.
My database is sqlserver2000 and using visualstudio.net 2003

my scrapbook should be like this :
it has a textbox for writing the topic
a textbox for writing name
a textbox for writing the message.

a user writes a message in the scrapbook(textbox) of his friend and click on the button to send.after that,the user can see his message and also other messages in the scrapbook...

I know how to insert the data in table(database) but I dont know how to show the last and also the previous messages in the page...
thanks alot.

User 66588-Dec-06 5:55

User 6658

8-Dec-06 5:55

sanaziuse wrote:
I need the C#.net code for scrapbook.

sanaziuse wrote:
I want to write and create a scrapbook

So who now, you or we?

modified 12-Sep-18 21:01pm.

sanaziuse8-Dec-06 6:12

sanaziuse

8-Dec-06 6:12

I am trying...but i just could insert into database...so please help me with entire code...or give me the whole code for scrapbook
thank you

Colin Angus Mackay8-Dec-06 6:40

Colin Angus Mackay

8-Dec-06 6:40

sanaziuse wrote:
so please help me with entire code...or give me the whole code for scrapbook

We are not going to do that - In order to do that would take more space that is wise for a forum post.

You must try first, and when you get stuck you can come for help but we are not going to give you the "entire" code for the "whole" project. Not unless you are willing to pay us - we are not here to do your work for you. We are here becuase we like to help people, but we are only willing to help those that at least make an attempt themselves.

ed^nrgc8-Dec-06 6:01