ASP.NET

Abhishek Sur30-Sep-09 23:45

30-Sep-09 23:45

getramonweb wrote:
when i upload in FTP

AFAIK, IIS 6 doesnt support requests without extensions. So any request made without extension, will not be handled properly.
Use an extension and register it with IIS. Smile | :)

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Ramkumar_S30-Sep-09 23:57

Ramkumar_S

30-Sep-09 23:57

Thanks (it was great help for us)..

Is it possible to do without extension...because you know http://www.dotnetkicks.com/wpf was developed using this..

Ramkumar

Abhishek Sur1-Oct-09 0:02

1-Oct-09 0:02

Yes.. I think IIS 7 supports url without extension.

I dont know if there is any fix for this in IIS 6, as MVC does this as well. Smile | :)

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Alignment proble in firefox

Ramkumar_S1-Oct-09 0:16

Ramkumar_S

1-Oct-09 0:16

Thanks ..Let me check with this...bye

Ramkumar

benams30-Sep-09 23:37

benams

30-Sep-09 23:37

I have a table, some menus and images aligned to the center. When I go to my site with explorer it usually looks great, but in firefox it's not aligned(the problem also occurs in some explorer versions). my site : http://eturim.co.il/he/default.aspx?page=home[^]

do you have any solution?

Re: Alignment proble in firefox

S.Dhanasekaran1-Oct-09 3:06

S.Dhanasekaran

1-Oct-09 3:06

Hi...

In IE browser take a width in pixels as default. But in Mozilla u must set in Percentage(%) only. Ex: style="width:30%"

not able to insert the values

sumanmks30-Sep-09 23:35

sumanmks

30-Sep-09 23:35

hi i am very new to asp.net. It may be the simplest problem to u. but for me it is a bit difficult. I have written a code for inserting the values in the SQLEXPRESS in C#.but not able to insert it. Can Any one help me out. the code is as follows:
protected void Button1_Click1(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = @"Data Source=localhost\SQLEXPRESS;" +
"Initial Catalog=testdata;Integrated Security=SSPI";
try
{
myConnection.Open();
Label1.Text = "Server Version: " + myConnection.ServerVersion;
Label1.Text += " Connection Is: " +
myConnection.State.ToString();
string insertSQL;
insertSQL = "INSERT INTO jobseekerinfo (";
insertSQL += "firstname, middlename, lastname, ";
insertSQL += "dob, address, city, state, zip, mobile, phone, engcollege, ";
insertSQL += "enguniversity, engaggergate, pucollege, puuniversity, pumarks,";
insertSQL += "school, scuniversity, scmarks, totalyears, totalmonths,";
insertSQL += "workplace, job, skills";
insertSQL += "VALUES ('";
insertSQL += TextBox1.Text + "', '";
insertSQL += TextBox2.Text + "', '";
insertSQL += TextBox3.Text + "', '";
insertSQL += TextBox29.Text + "', '";
insertSQL += TextBox5.Text + "', '";
insertSQL += TextBox11.Text + "', '";
insertSQL += TextBox12.Text + "', '";
insertSQL += TextBox14.Text + "', '";
insertSQL += TextBox6.Text + "', '";
insertSQL += TextBox15.Text + "', '";
insertSQL += TextBox4.Text + "', '";
insertSQL += TextBox8.Text + "', '";
insertSQL += TextBox9.Text + "', '";
insertSQL += TextBox10.Text + "', '";
insertSQL += TextBox30.Text + "', '";
insertSQL += TextBox31.Text + "', '";
insertSQL += TextBox32.Text + "', '";
insertSQL += TextBox33.Text + "', '";
insertSQL += TextBox34.Text + "', '";
insertSQL += TextBox35.Text + "', '";
insertSQL += TextBox36.Text + "', '";
insertSQL += TextBox18.Text + "', '";
insertSQL += TextBox19.Text + "', '";
insertSQL += TextBox20.Text + "', '";
insertSQL += "')";
SqlCommand cmd = new SqlCommand(insertSQL, myConnection);
int added = 0;
added = cmd.ExecuteNonQuery();
Label1.Text = added.ToString() + " records inserted.";
}

finally
{
myConnection.Close();
Label1.Text += " Connection Is: " +
myConnection.State.ToString();

}
}

Thanks in advance

Greg Chelstowski30-Sep-09 23:48

Greg Chelstowski

30-Sep-09 23:48

Even though this is madness, i think it's going to work when you close the bracket here:

<br />
insertSQL += "workplace, job, skills";<br />
insertSQL+=") ";<br />
insertSQL += "VALUES ('";<br />

and get rid of the comma here:

<br />
insertSQL += TextBox20.Text;<br />

What I really want to say is, before bothering other people, DEBUG your project.
Oh, and once you've done it, and your project inserts your data, read up on sql injection.
And parameterized queries.
And how to store your connection string in web.config.

var question = (_2b || !(_2b));

Paramhans Dubey30-Sep-09 23:50

Paramhans Dubey

30-Sep-09 23:50

what is the error message?

sumanmks30-Sep-09 23:59

sumanmks

30-Sep-09 23:59

hi sir,
there r no syntax errors

Greg Chelstowski1-Oct-09 0:06

Greg Chelstowski

1-Oct-09 0:06

For crying out loud man, your t-sql is totally out of whack.

There might not be any syntax error in your C# project, all it sees is building a string for the most part.
~~What is the exception caught?~~
Did you debug it?
I bet the farm though, your insert statement has been built incorrectly, because one can plainly see that looking at it. As i said, close the damn bracket and get rid of the comma, would you?

Oh yeah, sorry.
I hadnt noticed you're not even CATCHING the exception.
Well, good luck--

var question = (_2b || !(_2b));

Paramhans Dubey1-Oct-09 0:08

Paramhans Dubey

1-Oct-09 0:08

<code>insertSQL += "workplace, job, skills)";
insertSQL += "VALUES ('";

you missed the )

Greg Chelstowski1-Oct-09 0:10

Greg Chelstowski

1-Oct-09 0:10

Should I use my invisibility to fight crime or for evil.
Look at the first reply, Captain Obvious.
And my next one.

And at the end of his insertSQL+= crap, see that there's an unnecessary comma being sent along with the rest of the T-SQL.

Ok, that's it.

var question = (_2b || !(_2b));

Re: not able to insert the values [modified]

ksss_maheshece30-Sep-09 23:51

ksss_maheshece

30-Sep-09 23:51

It may be a sytex error
1) Ensure ur column names r right
2) compare front end values with database datatype. Thumbs Up | :thumbsup:

sashidhar30-Sep-09 23:52

sashidhar

30-Sep-09 23:52

try the below link
http://www.codeproject.com/Messages/3218117/Re-query.aspx[^]

sumanmks wrote:
i am very new to asp.net.

Try to learn Books and articles It May Help You A lot..!
Try To Use Efficient Coding..!

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

modified on Thursday, October 1, 2009 5:58 AM

Navigating between two independent projects through ASP.NET's TreeNode Control

novice developer30-Sep-09 23:27

novice developer

30-Sep-09 23:27

Hi
Is there any way to navigate between two independent projects through TreeNode control.

I want to use TreeNode control in one project and setting its property TreeNode.NavigateUrl which causes to navigate to other project's Default Page.

I do also want to come back to triggering project by link button event of second project.

Any help will prove a great benefit to me Smile | :)

Anxiously waiting for reply.

Regards
Novice Developer

Refresh main page

samerh30-Sep-09 23:18

samerh

30-Sep-09 23:18

Hi all
i need to refresh the whole page when pressing a button inside an iframe.
i have a page View inside View.aspx i have an iframe named folder when i press save inside folder i return an id. I need to refresh the whole page (View.aspx) and pass querystring id to Iframe Folder.
Any help, thanks

Re: Refresh main page

Abhishek Sur30-Sep-09 23:41

how to create a subreport in subreport of mainreport or a subreport hierarchy in crystal reports?

30-Sep-09 23:41

how about window.parent.document.form[0].submit ??

You need to find the form from window.parent which represents the original page where Iframe is in. Smile | :)

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: Refresh main page

samerh30-Sep-09 23:45

samerh

30-Sep-09 23:45

Thanks for ur answer, however this is the issue. I am not being able to find the parent window in any way, there is no parent at all. i tried to use parent.location.reload(True) but gives an error parent is nothing.

Sandesh M Patil30-Sep-09 22:53

Sandesh M Patil

30-Sep-09 22:53

Please send me the answer

Re: how to create a subreport in subreport of mainreport or a subreport hierarchy in crystal reports?

Richard MacCutchan30-Sep-09 23:27

Richard MacCutchan

30-Sep-09 23:27

sandympatil wrote:
Please send me the answer

42!

further login info

vikas shukla30-Sep-09 22:39

vikas shukla

30-Sep-09 22:39

hi sir

is there any way so that we can add sql connection to crystal report for any system.i mean i'll free to move my application on any system.there will no further login information ask by crstal report.

Re: further login info

Abhishek Sur30-Sep-09 22:48