.NET (Core and Framework)

Shameel26-Oct-09 23:59

Shameel

26-Oct-09 23:59

Please post your code and the compiler/runtime error messages.

Amit Spadez27-Oct-09 0:03

Amit Spadez

27-Oct-09 0:03

When i run tje application, it executes successfully but after entering the login info..there generates an error "Instance Failure"

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Configuration;
using System.Data.SqlClient;

namespace Ads_Sertrack_System
{
public partial class frmLogin : Form
{
public frmLogin()
{
InitializeComponent();
this.MaximizeBox = false;
this.MinimizeBox = false;
this.StartPosition = FormStartPosition.CenterScreen;
this.WindowState = FormWindowState.Normal;
this.AutoSizeMode = AutoSizeMode.GrowOnly;
this.AutoSize = true;
}
SqlConnection conAdSertrack = new SqlConnection();
string strQry;
SqlCommand cmdLogin;
SqlDataReader dtrLogin;
public static int intLogInId;
public static string strUserName;
public static string strUserRole;

private void frmLogin_Load(object sender, EventArgs e)
{
try
{
conAdSertrack.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ToString();
}
catch (Exception expMsg)
{
MessageBox.Show(expMsg.Message.ToString(), "Alpha Net Technologies Pvt. Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}

private void btnLogin_Click(object sender, EventArgs e)
{
try
{
errProvider.Clear();
if (txtUserName.Text == "")
{
errProvider.SetError(txtUserName, "Please Enter User Name");
MessageBox.Show("Please Enter User Name", "Alpha Net Technologies Pvt. Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtUserName.Focus();
}
else if (txtPassword.Text == "")
{
errProvider.SetError(txtPassword, "Please Enter Password");
MessageBox.Show("Please Enter Password", "Alpha Net Technologies Pvt. Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtPassword.Focus();
}
else
{
strQry = "select userid,username,userrole" +
" from tblusermaster where username = @paramUNm and pwd = @paramPwd";
cmdLogin = new SqlCommand(strQry, conAdSertrack);

cmdLogin.Parameters.Add("@paramUNm", SqlDbType.VarChar, 30).Value = txtUserName.Text;
cmdLogin.Parameters.Add("@paramPwd", SqlDbType.VarChar, 30).Value = txtPassword.Text;
if (conAdSertrack.State == ConnectionState.Closed)
{
conAdSertrack.Open();
}
dtrLogin = cmdLogin.ExecuteReader();
if (dtrLogin.HasRows)
{
dtrLogin.Read();

intLogInId = Convert.ToInt32(dtrLogin[0].ToString().Trim());
strUserName = Convert.ToString(dtrLogin[1].ToString().Trim());
strUserRole = Convert.ToString(dtrLogin[2].ToString().Trim());

frmMDI formMdi = new frmMDI();
formMdi.Show();
this.txtPassword.Text = "";
this.txtUserName.Text = "";

this.Hide();
}
else
{
MessageBox.Show("InValid User Name & Password", "Alpha Net Technologies Pvt. Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtUserName.Text = "";
txtPassword.Text = "";
txtUserName.Focus();
}
dtrLogin.Close();
conAdSertrack.Close();
}
}
catch (Exception expMsg)
{
MessageBox.Show(expMsg.Message.ToString(), "Innor Solutions Pvt. Ltd", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}

private void btnCancel_Click(object sender, EventArgs e)
{
try
{
Application.Exit();
}
catch (Exception expMsg)
{
MessageBox.Show(expMsg.Message.ToString(), "Alpha Net Technologies Pvt. Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}

private void frmLogin_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
Application.Exit();
}
catch (Exception expMsg)
{
MessageBox.Show(expMsg.Message.ToString(), "Alpha Net Technologies Pvt. Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}

private void txtUserName_TextChanged(object sender, EventArgs e)
{
try
{
errProvider.Clear();
}
catch (Exception expMsg)
{
MessageBox.Show(expMsg.Message.ToString(), "Alpha Net Technologies Pvt. Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}

private void txtPassword_TextChanged(object sender, EventArgs e)
{
try
{
errProvider.Clear();
}
catch (Exception expMsg)
{
MessageBox.Show(expMsg.Message.ToString(), "Alpha Net Technologies Pvt. Ltd: Message Service", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}

Covean27-Oct-09 0:16

Covean

27-Oct-09 0:16

Can you please post your connectionstring and what database do you use (maybe SQL-Server Express 2005?).

Amit Spadez27-Oct-09 0:17

Amit Spadez

27-Oct-09 0:17

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="con" connectionString="Server=.\\sqlexpress;Integrated Security=true; Initial Catalog=AdSertrack_WinPrj;User Instance=false;"/>
</connectionStrings>
</configuration>

Covean27-Oct-09 0:20

Covean

27-Oct-09 0:20

Try server=.\SQLExpress. (only one \)

Amit Spadez27-Oct-09 0:24

Amit Spadez

27-Oct-09 0:24

thanks man ..i got it..

Tabbed ListBox in a Web Page

Covean27-Oct-09 0:34

Covean

27-Oct-09 0:34

No problem.

And if I may say so, its not the best way to execute sql-queries directly in your UI.

MarkyMark196126-Oct-09 8:21

26-Oct-09 8:21

I am trying to create a Tabbed List Box in a web page. I have done it in a windows application and it worked perfectly, but I can't find one little tiny piece of information and need some help.

I am trying to use SendMessage with the ListBox and all the examples I see say to use this:

SendMessage(List1.hWnd, LB_SETTABSTOPS, ListBoxTabs.Length, ref ListBoxTabs[0]);

However! There is no hWnd property for the ListBox control. In the windows app it's List1.Handle, however, there is no such property for that in the web control either! Can someone explain to me how to find the hWnd property of a web ListBox?

Thanks in advance for any help you can give.

Not Active26-Oct-09 8:31

26-Oct-09 8:31

MarkyMark1961 wrote:
Can someone explain to me how to find the hWnd property of a web ListBox?

There isn't one. You need to spend some time reading up on how to create server controls for ASP.NET before proceeding.

only two letters away from being an asset

MarkyMark196126-Oct-09 8:41

26-Oct-09 8:41

Then why are there examples showing that there is?

Not Active26-Oct-09 8:52

26-Oct-09 8:52

You are most likely confused. Show these sources.

only two letters away from being an asset

MarkyMark196126-Oct-09 9:00

26-Oct-09 9:00

try this one it shows exactly what I was saying among others...

http://www.vb-helper.com/howto_listbox_tabs.html

Not Active26-Oct-09 9:05

26-Oct-09 9:05

Yes, you are very confused.

One, this is for a Windows application. As we have told you SendMessage is not available in ASP.NET.
Two, you are using VB

only two letters away from being an asset

MarkyMark196126-Oct-09 9:09

26-Oct-09 9:09

You're absolutely right! You ARE only two letters away from being an asset!

MarkyMark196126-Oct-09 9:04

26-Oct-09 9:04

Or this one....

http://www.devx.com/vb2themax/Tip/18592

If you don't have anything helpful or constructive to contribute, then why contribute at all?

Not Active26-Oct-09 9:08

26-Oct-09 9:08

Again, Windows, not ASP.NET.

Seriously, stop what you are doing and start reading up on ASP.NET.

only two letters away from being an asset

Not Active26-Oct-09 9:36

26-Oct-09 9:36

Because you are told you don't understand a topic and are given the advice to study it, you vote 1? Very mature. If it was not you, then the same goes for whomever did. At least identify yourself and accept the responsibility to explain why.

only two letters away from being an asset