ASP.NET

Franco Cipriano25-May-12 5:45

25-May-12 5:45

I tried your suggestions but, this time everytime I click the select button it still gives me the same error. Here is the code behind from the WebForm1.aspx

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;

namespace AccoutMgt
{
    public partial class WebForm1 : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {
            if (Page.Request.QueryString["name"] != null)
            {
                txtMPSname.Text = Page.Request.QueryString["name"];
                txtLoc.Text = Page.Request.QueryString["location"];
                DlstGeo.DataValueField = Page.Request.QueryString["geo"];
            }
        }

        protected void BtnSearch_Click(object sender, EventArgs e)
        {

        }

    }
}

and here is the code from frmList.aspx

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;


namespace AccoutMgt
{
    public partial class List : System.Web.UI.Page
    {
        //public static string connStr = "SERVER=157.184.82.187;DATABASE=acctinformation;UID=root;PASSWORD=l3xmark;pooling=false;";
        //public static MySqlConnection mycon;
        //ClassProj cs1 = new ClassProj();
        
        protected void Page_Load(object sender, EventArgs e)
        {
            if (ClassProj.GetDBconn() == true)
            {
                if (!IsPostBack)
                {
                    String SQLstr = "SELECT a.ID, a.NAME AS Name,b.NAME AS Industry,a.subindustry as SubIndustry,a.geo AS Geo,c.NAME AS LocType FROM mpsacct AS a,industry AS b,location AS c WHERE a.industry=b.id AND a.loctype=c.id";
                    MySqlCommand cmd = new MySqlCommand(SQLstr, ClassProj.mycon);
                    MySqlDataReader reader = cmd.ExecuteReader();

                    //Bind the grid view
                    grdAll.DataSource = reader;
                    grdAll.DataBind();

                    reader.Close();
                    cmd.Dispose();
                }
            }

            ClassProj.CloseConn();
        }

        public void MPS_Selected(Object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Select")
            {
                // Convert the row index stored in the CommandArgument
                // property to an Integer.
                int index = Convert.ToInt32(e.CommandArgument);
                //Populate textbox with selected values

                //String s = Request.QueryString["grdAll.Rows[index].Cells[1].Text.ToString();"];
                string name = grdAll.Rows[index].Cells[1].Text.ToString();
                string Industry = grdAll.Rows[index].Cells[2].Text.ToString();
                string SubInd = grdAll.Rows[index].Cells[3].Text.ToString();
                string geo = grdAll.Rows[index].Cells[4].Text.ToString();
                string location = grdAll.Rows[index].Cells[5].Text.ToString();

                Page.Response.Redirect("~/WebForm1.aspx?name=" + name + "&industry=" + Industry + "&subind=" + SubInd + "&geo=" + geo + "&location=" + location);
            }
        }

               
    }
}

ZurdoDev25-May-12 5:50

25-May-12 5:50

Is WebForm1 in the root of the site? That is what the ~ does. It puts you to the root so make sure that Response.Redirect(path) is correct.

There are only 10 types of people in the world, those who understand binary and those who don't.

Franco Cipriano25-May-12 7:11

25-May-12 7:11

They are located on the same path. The WebForm1.aspx is the start page and serves as the parent. The frmList.aspx is a pop-up window. Basically what should happen is the frmList.aspx will call back the WebForm1.aspx and pass the values to the controls of WebForm1.aspx.

Thanks,

ZurdoDev25-May-12 7:18

25-May-12 7:18

I know, but is WebForm1 under a folder? Or is it at the root of your site?

There are only 10 types of people in the world, those who understand binary and those who don't.

Franco Cipriano25-May-12 7:27

25-May-12 7:27

It's in the root of the site. I'm not sure where the problem is, since when I run the debug it does not go anywhere when I click the button in the GridView. Here is the ASP code of the GridView at frmList.aspx

XML

<asp:GridView ID="grdAll" runat="server" OnRowCommand="MPS_Selected" AutoGenerateColumns="false">
            <Columns>
                <asp:BoundField DataField="ID" HeaderText = "" Visible="false" />
                <asp:BoundField DataField="Name" HeaderText = "MPS Account Name" />
                <asp:BoundField DataField="Industry" HeaderText = "Industry" />
                <asp:BoundField DataField="SubIndustry" HeaderText = "Sub-Industry" />
                <asp:BoundField DataField="Geo" HeaderText = "Geo" />
                <asp:BoundField DataField="LocType" HeaderText = "Location" />
                <asp:buttonfield buttontype="Button" commandname="Select" headertext="" text="Select"/>
            </Columns>

        </asp:GridView>

ZurdoDev25-May-12 7:30

25-May-12 7:30

404 means it cannot find the file. So, put a breakpoint and see what url it is trying to go to. Also, if the url is correct try adding the Everyone group to the folder with full control because you may have an issue where file level security is preventing IIS from seeing the file.

There are only 10 types of people in the world, those who understand binary and those who don't.

Franco Cipriano25-May-12 7:38

25-May-12 7:38

Hi,

Where do I do that in the file? Sorry for the questions, I am very new to this. I just started a week ago. And I am stuck on finding a way of passing back a value from a page to it's parent page.

Thanks,

ZurdoDev25-May-12 7:39

25-May-12 7:39

Can you post a screen shot of the file structure maybe?

There are only 10 types of people in the world, those who understand binary and those who don't.

Franco Cipriano27-May-12 21:03

27-May-12 21:03

This is the method that I use to show a new window, I'm not sure what is wrong but it won't work anymore

protected void btnAll_Click(object sender, EventArgs e)
       {

           System.Text.StringBuilder sb = new System.Text.StringBuilder();
           sb.Append("<script language='javascript'>");
           sb.Append("window.open('frmList.aspx', 'MPS Account List',");
           sb.Append("'top=0, left=0, width='500', height='700', menubar=no,toolbar=yes,status,resizable=yes,addressbar=yes');<");
           sb.Append("/script>");

           Type t = this.GetType();

           if (!ClientScript.IsClientScriptBlockRegistered(t, "PopupScript"))
               ClientScript.RegisterClientScriptBlock(t, "PopupScript", sb.ToString());

       }

frostcox25-May-12 10:29

frostcox

25-May-12 10:29

Hey, have you debugged through your code and seen where it exactly crashes? place breakpoints in each function and see what exactly is the problem. Like the app could be failing because the url is incorrect, or it might be trying to parse out a value that is not there from your querystring. Anyway find out exactly where its crashing and il gladly help you.

Franco Cipriano27-May-12 21:13

27-May-12 21:13

Yes, I placed some breakpoints, but when I click on the button where it will pop-up a window it won't stop on the breakpoint..here is the code for the pop-up window and the code for the passing back the value from the gridview to the parent page.

//code for pop-up window

protected void btnAll_Click(object sender, EventArgs e)
       {

           System.Text.StringBuilder sb = new System.Text.StringBuilder();
           sb.Append("<script language='javascript'>");
           sb.Append("window.open('frmList.aspx', 'MPS Account List',");
           sb.Append("'top=0, left=0, width='500', height='700', menubar=no,toolbar=yes,status,resizable=yes,addressbar=yes');<");
           sb.Append("/script>");

           Type t = this.GetType();

           if (!ClientScript.IsClientScriptBlockRegistered(t, "PopupScript"))
               ClientScript.RegisterClientScriptBlock(t, "PopupScript", sb.ToString());

       }

//code for passing value back

public void MPS_Selected(Object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Select")
            {

                ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script type='text/javascript'>alert('msg！')</script>");

                // Convert the row index stored in the CommandArgument
                // property to an Integer.
                int index = Convert.ToInt32(e.CommandArgument);
                //Populate textbox with selected values

                //String s = Request.QueryString["grdAll.Rows[index].Cells[1].Text.ToString();"];
                string name = grdAll.Rows[index].Cells[1].Text.ToString();
                string Industry = grdAll.Rows[index].Cells[2].Text.ToString();
                string SubInd = grdAll.Rows[index].Cells[3].Text.ToString();
                string geo = grdAll.Rows[index].Cells[4].Text.ToString();
                string location = grdAll.Rows[index].Cells[5].Text.ToString();

                Page.Response.Redirect("~/WebForm1.aspx?name=" + name + "&industry=" + Industry + "&subind=" + SubInd + "&geo=" + geo + "&location=" + location);


                //HttpContext _context = HttpContext.Current;
                //_context.Items.Add("name", name);
                //Server.Transfer("~/WebForm1.aspx");


            }
        }

wikizhao25-May-12 16:14

wikizhao

25-May-12 16:14

may be you can use

ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('msg！')");

show you info.the Response when you jump another page,that can

use.

did you ?

Franco Cipriano27-May-12 21:16

27-May-12 21:16

what should I put on the 'msg!'? when the place this code on the method it only pop's up msg on the messagebox.

Thanks!

Regarding Availability of a username in Asp.net

wikizhao28-May-12 17:41

wikizhao

28-May-12 17:41

'msg!' mean info you want to put on this pleace!

string

try{}catch{} this things that all you can put on it!It loooks like UI page

javascript alert(""); Hope can help you

anu.koshy8524-May-12 23:13

anu.koshy85

24-May-12 23:13

Hi everybody,

I want to check username entered is already available in sqlserver 2008 database. can anyone help me?

Thanks for any help in Advance

Regards

Anu Koshy

Re: Regarding Availability of a username in Asp.net

Richard MacCutchan25-May-12 1:14

Richard MacCutchan

25-May-12 1:14

My SQL skills are almost non-existent, but surely querying for a particular name in a username list or table, will tell you whether it exists or not. Probably some form of

SQL

SELECT * from usertable WHERE username = 'name to test'

Programming is work, it isn't finger painting. Luc Pattyn

Re: Regarding Availability of a username in Asp.net

anu.koshy8525-May-12 4:19

anu.koshy85

25-May-12 4:19

Hi,

I am using stored procedure. I tried this sql... But the problem is when executing this stored procedure, I didnt get the return value. If i get, it always be -ve or zero.

Thanks

Regards
Anu Koshy

Re: Regarding Availability of a username in Asp.net

ZurdoDev25-May-12 4:45

Re: Regarding Availability of a username in Asp.net

25-May-12 4:45

So, change the stored procedure to return the value you need. Or, post it here and tell us what you need and we can help.

There are only 10 types of people in the world, those who understand binary and those who don't.

vvashishta25-May-12 2:39

vvashishta

25-May-12 2:39

on Create Account button click event, write a function to check for UserName already exists by provided the UserName written in textbox as parameter to the function and that function will return a datatable with query in SQL as
SELECT * FROM TableName WHERE UserName = "Value In TextBox"

If datatable has any row, the user exists else not.

- Happy Coding -
Vishal Vashishta

Re: Regarding Availability of a username in Asp.net

David Mujica25-May-12 6:13

David Mujica

25-May-12 6:13

I beleive the table you are looking for is: sysusers

Something like this ...

select * from sysusers = 'myDesiredUser'

Rememeber the user that you use to issue this query needs to have the necessary security permissions to this system table.

Re: Regarding Availability of a username in Asp.net

wikizhao25-May-12 16:17

wikizhao

25-May-12 16:17

Oh! the server 2008 is't high ,I am now in user 2005.

But 08 more same with 05 ,may be you can check the user team,

create a new user and give the admin power ,try to enter system!

Tab Control

niyajahmad24-May-12 18:56

niyajahmad

24-May-12 18:56

How to make a tab control in asp.net with C# in vs 2010

Re: Tab Control

vvashishta25-May-12 2:40

vvashishta

25-May-12 2:40

You can use AjaxControlToolkit for this,
TabControlExtender is the control you have to use.

- Happy Coding -
Vishal Vashishta

Re: Tab Control

ZurdoDev25-May-12 4:45