If Exists problem

I want to enter a website address into a TextBox and on AutoPostBack check to see if the entry is LIKE any in a SQL 2000 database tblLinkAddresses. If it is not - add it to the table and if it is display the LIKE matches.

Where do I start?

I am stupid - got the if it matches problem solved - just need to know how to add a textbox entry to a database table on a button click.

|||

SqlConnection _sqlconnection=new SqlConnection('place your connectionstring')

_sqlconnection.Open();

SqlCommand _cmd=new SqlCommand('your stored procedurename ',_sqlconnection);

_cmd.CommandType=CommandType.Storedprocedure;

_cmd.Parameter.Add(new SqlParameter('@.parametername',SqlDBType.Varchar,50));

_cmd.Parameter["@.parametername"].value=Text1.Text;

_cmd.ExecuteNonQuery()

IE7 script error when opening Infopath forms

Hi,

I installed IE7 recently and it is giving me problems when I open Infopath forms to edit documents. I have a sharepoint website which contain links to these forms, when I click on the link it opens the infopath form. It was working absolutely fine when I used IE6. But now when I open the infopath form it gives me an error saying that

A Runtime error has occured

Line: 38

Error: Object Expected

When I open it in the debugger it shows me an error at <body onLoad="onLoad()">. Could someone please advice!

I appreciate a quick response.

Thanks

What does this have to do with SSRS?|||

oops! sorry i created the new thread in the wrong forum. I need to put it in IE7 forum. Could someone tell me how I do that?

Thanks

IE cannot access Webpage for Report Manager-what can I do?

Greetings,
I am trying to access the Report Manager website, but I am getting an error
message (http 403) that IE can connect to the website but doesn't have the
permision - requires login. Here is what I did - I am at the server computer
logged in as administrator (the builtin administrator - sa). I go to
Start/all programs/Microsoft Sql Server/Reporting Services/Report Manager.
This brings up IE to the webpage where I get the message that I am not
authorized to access the site (error http 403) and that I need to log in.
But there is no login box anywhere. What do I need to do to access the
Report Manager site? Do I need to configure something in my Server
Administration? Or do I need to configure something in IIS?
Thanks,
RichI went to IIS to the Reports Virtual directory to Pages and found
Folder.aspx. The security set on the Reports dir is Window Integrated
security and the same for the Pages directory. It says that the user will
need to enter an ID/password. But when I try to bring up
http://myserver/reports/pages/folder.aspx all I get is the error message
"...Forbidden..." and I do not get the logon dialog.
Do I need to modify something in IIS?
"Rich" wrote:
> Greetings,
> I am trying to access the Report Manager website, but I am getting an error
> message (http 403) that IE can connect to the website but doesn't have the
> permision - requires login. Here is what I did - I am at the server computer
> logged in as administrator (the builtin administrator - sa). I go to
> Start/all programs/Microsoft Sql Server/Reporting Services/Report Manager.
> This brings up IE to the webpage where I get the message that I am not
> authorized to access the site (error http 403) and that I need to log in.
> But there is no login box anywhere. What do I need to do to access the
> Report Manager site? Do I need to configure something in my Server
> Administration? Or do I need to configure something in IIS?
> Thanks,
> Rich