Comments by msweety - CodeProject

msweety 1-Dec-12 6:31am View

i want to display the data in textboxes according to the selected value in dropdown list. need to select based on selected text. how to pass the selected text value to a stored proc?
pls help me

protected void ddlDisplayName_SelectedIndexChanged(object sender, EventArgs e)
{
AdminActivityBL ObjAdminActivity = new AdminActivityBL();
ObjAdminActivity.GetDisplayNames_Details();
string SelectedValue = ddlDisplayName.SelectedText.Value;

}
Bussines layer:

public DataSet GetDisplayNamesDetails()
{
AdminActivityDB objAdminActivityDB = new AdminActivityDB();
return objAdminActivityDB.GetDisplayNamesDetails();
}

Data access layer:

public DataSet GetDisplayNamesDetails(string SelectedValue)
{
try
{
Database objDB = new SqlDatabase(ConfigurationHelper.ConnectionString);
using (DbCommand objCMD = objDB.GetStoredProcCommand(Constants.USP_GET_DISPLAYNAMES_DETAILS))
{
DataSet retDS = objDB.ExecuteDataSet(objCMD);
return retDS;
}
}
catch (Exception ex)
{
//EventLog objLog = new EventLog();
//objLog.LogError(ex);

throw ex;
}

}

msweety 1-Dec-12 3:45am View

i really didnot get...that..could you please explain with sample...code

msweety 1-Dec-12 3:18am View

i want to pass by using selectedtext from the dropdown

protected void ddlDisplayName_SelectedIndexChanged(object sender, EventArgs e)
{
AdminActivityBL ObjAdminActivity = new AdminActivityBL();
ObjAdminActivity.GetDisplayNames_Details(DisplayName);
string SelectedValue = ddlDisplayName.SelectedItem.Value;

}
is this correct?

msweety 30-Nov-12 8:46am View

hi mohd,

i want to display the data from database as per the selected value of dropdown.

pls see my code:
.aspx.cs
protected void ddlDisplayName_SelectedIndexChanged(object sender, EventArgs e)
{
AdminActivityBL ObjAdminActivity = new AdminActivityBL();
ObjAdminActivity.GetDisplayNames_Details();
string SelectedValue = ddlDisplayName.SelectedItem.Value;

}
Bussines layer:

public DataSet GetDisplayNamesDetails()
{
AdminActivityDB objAdminActivityDB = new AdminActivityDB();
return objAdminActivityDB.GetDisplayNamesDetails();
}

dataaccess layer:

public DataSet GetDisplayNamesDetails()
{
try
{
Database objDB = new SqlDatabase(ConfigurationHelper.ConnectionString);
using (DbCommand objCMD = objDB.GetStoredProcCommand(Constants.USP_GET_DISPLAYNAMES_DETAILS))
{
DataSet retDS = objDB.ExecuteDataSet(objCMD);
return retDS;
}
}
catch (Exception ex)
{
//EventLog objLog = new EventLog();
//objLog.LogError(ex);

throw ex;
}

}.

is this something right?

:-)

msweety 30-Nov-12 8:09am View

hi mohd,

i want to display the data from database as per the selected value of dropdown.

pls see my code:
.aspx.cs
protected void ddlDisplayName_SelectedIndexChanged(object sender, EventArgs e)
{
AdminActivityBL ObjAdminActivity = new AdminActivityBL();
ObjAdminActivity.GetDisplayNames_Details();
string SelectedValue = ddlDisplayName.SelectedItem.Value;

}
Bussines layer:

public DataSet GetDisplayNamesDetails()
{
AdminActivityDB objAdminActivityDB = new AdminActivityDB();
return objAdminActivityDB.GetDisplayNamesDetails();
}

dataaccess layer:

public DataSet GetDisplayNamesDetails()
{
try
{
Database objDB = new SqlDatabase(ConfigurationHelper.ConnectionString);
using (DbCommand objCMD = objDB.GetStoredProcCommand(Constants.USP_GET_DISPLAYNAMES_DETAILS))
{
DataSet retDS = objDB.ExecuteDataSet(objCMD);
return retDS;
}
}
catch (Exception ex)
{
//EventLog objLog = new EventLog();
//objLog.LogError(ex);

throw ex;
}

}.

is this something right?

:-)

msweety 29-Nov-12 6:27am View

aceepted :-)

now pls explain how to collbrate that code to my 3 layer architechure...

msweety 29-Nov-12 6:12am View

thanks :-)

i really i didnot get how to use it in my 3 layer architechure.

var d = new Date()
var n = d.getTimezoneOffset();

msweety 29-Nov-12 6:03am View

thanks for the speedy response.
i am not using any lalbel to dispaly the date and time i just need to read the system date and time to insert into database.

i hope i am clear :-)

msweety 29-Nov-12 5:53am View

i need from client side..(user's system) which is to be inserted in the database.

msweety 29-Nov-12 3:20am View

hi mohd.. i have populated the dropdown list values from stored proc in database. now i have to store the selected dropdownlist value to database on clicking the add button.

Could you pls help me out..in this

msweety 28-Nov-12 8:59am View

thanks a lot Mohd it helped me a lot....:-)

msweety 28-Nov-12 6:11am View

under .cs page I would like to dynamically fill the dataset with a stored procedure here

msweety 28-Nov-12 5:36am View

thanks again could you also pls help in wirting the code under the dropdown list button.?

protected void ddlLobGrpId_SelectedIndexChanged(object sender, EventArgs e)
{

}

msweety 28-Nov-12 5:19am View

Hi Mohd,

thanks for the response it helped me...
could you pls let knoe where to write the bind dropdown code?

thanks in advance :-)

Comments by msweety (Top 14 by date)