Re: connection code in app_cofig file using windows form - ASP.NET Discussion Boards

Hi,friends
i hav set allow paging property to true.
Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
cmd.Connection = cn
cmd.CommandText = "select * from EMP_DETAILS"
cn.Open()
grd.DataSource = cmd.ExecuteReader
grd.DataBind()
cn.Close()
End Sub
This is the error iam getting.
The data source does not support server-side data paging.
Suggest me to handle the error.

Thank u

you need to bind to a datatable, not a datareader

Use Datatable or Dataset instead of Datareader.

SSK.

Hi
I am tryin to display an image which is stored in a database

i ahve a procedure which will go to the appropiate record in my database and pull the file name from it

it should then take the file name and put it into a prefixed img src tag, which should then take the appropiate file from the imagestore and display to the web page

it all seems to work fine, even when i check the html source file the tag has been filled with the valid address but it jus doesn't seem to want to render the image

Is there anythin i need to do here? here is my code

<code> Sub getimage(ByVal sender As Object, ByVal e As EventArgs)
'Create connection string to pass database, string holds login information to mySQL,
Dim connectionString As String
connectionString = "Server=localhost; u;database=ftp1;"

'Builds .net mysql connection and passes connection string into method
Dim connection As New MySqlConnection(connectionString)

'Create mySql command string for passing query or SPROC(Stored Procedure)
Dim cmdString As New MySqlCommand
'Set Command to equal mySql connection,t so can pass SQL query
cmdString.Connection = connection

'Set command string to equal SPROC
cmdString.CommandText = "sp_getImage"
'ONLY PLACE THIS IF SPROC, sets the command to a SPROC
cmdString.CommandType = CommandType.StoredProcedure
Dim literr As New LiteralControl

Dim param As MySqlParameter
Try
'Creates parameter which will be passed into procedure
param = cmdString.Parameters.Add("?p_id", MySqlDbType.Int32)
'Sets parameter type equal to input
param.Direction = ParameterDirection.Input
'Sets parameter value equal to value held in textbox
param.Value = 4

'Creates parameter to pass into SPROC
param = cmdString.Parameters.Add("?p_image", MySqlDbType.VarChar)
'Sets parameter type to output
cmdString.Parameters("?p_image").Direction = ParameterDirection.Output

connection.Open() 'Opens DB connection
cmdString.ExecuteNonQuery() 'Executes procedure and reads in OUTPUT parameter
connection.Close() 'Closes DB connection

Catch ex As Exception
literr.Text = ex.Message
MsgBox(ex.Message)

End Try
MsgBox(cmdString.Parameters("?p_image").Value)

Dim imageStore As String = cmdString.Parameters("?p_image").Value
MsgBox(imageStore)
imgHolder.ImageUrl = ("c:\test\" & imageStore)

End Sub

<asp:image runat=server ID="imgHolder" Height="282px" Width="488px" BackColor="Red" />
</code>

boyindie wrote:
when i check the html source file the tag has been filled with the valid address but it jus doesn't seem to want to render the image

You need to set teh ImageUrl to either a relative path from where the webpage is, or else a fully qualified web-address (http://www...etc). It can't just be any folder on your hard drive.

If your page is in the root folder of your website, adn the images in a subfo9lder called "images", you could set

imgHolder.ImageUrl = ("images/" & imageStore)

Your images folder (test) needs to be within your web application.

my connection code is:

String strConnection;
strConnection = "server=localhost;User ID=sa;Password=sas;database=db";
SqlConnection conn = new SqlConnection(strConnection);
conn.Open();

how will i write it in any application configuration file working in windows form,and call it on every page that needs to b connected??
can any body help me??

$h@ma!|@

i write in the folowing manner
<appsettings>
<add key="sqlserver" value="server=localhost;User
ID=sa;:Dassword=sa;database=db" ;="">

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

First and foremost, this is a VB.Net question (Not ASP.Net since you are using Win Forms) second in your app.config you need a < connectionStrings > < /connectionStrings > section (like below) then add your connection string as I have. The weird thing about your post is you ask how to make it work in the app.config in Windows Forms then you ask how to call it on every "page" taht needs it, Windows Forms dont have "pages". The below example will work in Windows Forms (which is what you asked).

As for the 2nd part of your question, the easiest way to call it is to write a function like below:

'This returns the connection string
    Public Shared Function GetConnectionString(ByVal strConnection As String) As String
        Dim strReturn As New String("")
       'If you have multiple connection strings then you can pass it a connection name otherwise it defaults to your default connection
        If Not String.IsNullOrEmpty(strConnection) Then
            strReturn = ConfigurationManager.ConnectionStrings(strConnection).ConnectionString
        Else
            strReturn = ConfigurationManager.ConnectionStrings("MyConnectionName").ConnectionString
        End If
        Return strReturn
    End Function

Then on the form that needs a DB connection call it like this:

Dim oConnection As New SqlConnection(YourClassName.GetConnectionString("MyConnectionName"))

<connectionstrings>
        <add name="MyConnectionName">
   connectionString="Persist Security Info=False;Data Source=localhost;Initial Catalog=db;Integrated Security=SSPI;Trusted_Connection=TRUE;Application Name=AppName"
            providerName="System.Data.SqlClient" />
  </add>
</connectionstrings>

If you mis-worded your question and need this for an ASP.Net application (not Windows Forms) reply and let me know and I'll help as much as I can

"Well yes, it is an Integer, but it's a metrosexual Integer. For all we know, under all that hair gel it could be a Boolean."
Tom Welch

in windows application i want to apply validation checks.i hv trued one for empty textbox
i.e.
if (textBox1.Text == "")
{
MessageBox.Show("Enter phone number", "Error in Input", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.textBox1.Clear();
this.textBox1.Focus();
return;
}

how to validate numbers and alphabetic characters??

try ur code on key press event
if(e.keychar>=67 && e.keychar<=90)
{
e.handed=true;
}

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

it is giving error
'System.Windows.Forms.KeyPressEventArgs' does not contain a definition for 'keychar'

software student

this is the code.
private void keypress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar >= 67 && e.KeyChar <= 90)
{
e.Handled = true;
}

}

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

I made a page using CreateUserWizard but I restrict it for Admins only. The problem is when an Admin create an account for the new user, after completing the steps, it automatically change the logged in Admin to the new created account. Is there anyway not to login after creating an account? Except for the Security setup wizard on ASP.NET Configuration. D'Oh! | :doh:

Thanks!

what code u r writing ?

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

I'm using Visual Studio 2005 and I'm writing ASP.Net pages. CreateUserWizard is very easy to use but I don't know how to change the settings so that after creating a new User, it will not automatically log-in on the user... Only Admins could create a new user.

Can you copy over the aspx code here?

<< >>

8x Solutions Ltd

I want to do it for Drag & Drop & upload.
i want to drag a file from my desktop & drop on my web page.
Can i getimage path,image which i dropped.
it will be a dynamic file may be some image, text file or anything.
Thanx In Advance.
Confused | :confused:

You'll need to embedd an activeX or .NET control into your page in order to offer this functionality, you can't do it otherwise.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

if u can get some help from this link.
Window application providing the drag and drop of image file , u can easily convert for txt or any file other then image file

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Thank you for your reply.

I was not think about window application. I want to Drag file from client's machine (e.g. Desktop) and Drop it on the web page. and upload it. Please try the code below in html file

http://www.codingforums.com/showthread.php?t=36896

I want same as above but I want to see all dragged images on web page in thumbnail format and the upload.

Thanks in advance.

hi
I am using asp.net 1.0.
My problem is, button click event firing two times wen i click one it.
how i solve this issue??

All I ever wanted is what others have....
CrazySanker

A button event generates a postback. There is no way you're getting two click events for one click, there's something wrong in your code. Try posting it.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

hello vipin,
I think the problem has arised due to the HTML design so plz check ur design. and also bcoz of the events that r fired when the page is created like initalze component(),page load,rendering... etc

ok try like that u will get byeee

Murali

Whenever I try to connect to the PUBS.MDF database, a login failed error message will appear.

I defined the connection string in the web.config file under the connectionstrings section like this:

[code]

add name="Pubs" connectionString="Data Source = localhost\SQLEXPRESS; Initial Catalog=Pubs;Integrated Security=SSPI"

[/code]

And setup the connection in the click event of a button:

[code]
Dim connectionString As String = WebConfigurationManager.ConnectionStrings("Pubs").ConnectionString

Dim myConnection As New SqlConnection(connectionString)

myConnection.Open()

..........
[/code]

And I put the PUBS.MDF file in the same folder as the vb source files.

How do I connect to the database correctly?

KaKa` wrote:
add name="Pubs" connectionString="Data Source = localhost\SQLEXPRESS; Initial Catalog=Pubs;Integrated Security=SSPI"

This looks for a named instance of SQL Server called SQLEXPRESS, and then tries to find a DB called pubs in there. It sure as hell isn't going to find a file called 'pubs.mdf' ( which is an access database )

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )