Click here to Skip to main content
14,268,822 members
   

ASP.NET

 
SuggestionRe: Expiry date and Update Expiry Date Pin
Richard Deeming15-Apr-19 8:25
mveRichard Deeming15-Apr-19 8:25 
AnswerRe: Expiry date and Update Expiry Date Pin
jkirkerx16-Apr-19 9:57
professionaljkirkerx16-Apr-19 9:57 
QuestionIn 3 tier architecture , filling textboxes with values from database table Pin
Member 1418527512-Apr-19 19:17
memberMember 1418527512-Apr-19 19:17 
AnswerRe: In 3 tier architecture , filling textboxes with values from database table Pin
Vinod Jangle15-Apr-19 7:49
memberVinod Jangle15-Apr-19 7:49 
GeneralRe: In 3 tier architecture , filling textboxes with values from database table Pin
Member 1418527515-Apr-19 8:46
memberMember 1418527515-Apr-19 8:46 
GeneralRe: In 3 tier architecture , filling textboxes with values from database table Pin
Vinod Jangle15-Apr-19 10:05
memberVinod Jangle15-Apr-19 10:05 
GeneralRe: In 3 tier architecture , filling textboxes with values from database table Pin
Member 1418527515-Apr-19 16:46
memberMember 1418527515-Apr-19 16:46 
GeneralRe: In 3 tier architecture , filling textboxes with values from database table Pin
Vinod Jangle16-Apr-19 3:18
memberVinod Jangle16-Apr-19 3:18 
Here you go. You need to extract data from data table now in below code to populate your variables which you may be binding on screen.

DAL:

public DataTable FetchDetails()
{
    con.Open();
    DataTable dt = new DataTable();
    using(SqlCommand cmd = new SqlCommand("spfetchdetail", con))
    {
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@pid", pid);
        
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        sda.Fill(dt);
    }
    return dt.Table[0];
}


BAL:

public DataTable fetchdetail()
{
    return dll.FetchDetails(); // Call to your DAL returning Datatable
}


CS:

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
    string pid = ""; string pname = ""; string pcid = ""; string sdesc = ""; string desc = ""; string qty = ""; string prce = ""; string len = "";
    DataTable dt = bll.fetchdetail(); // Call to BAL and reveice datatable
    // extract the data from this datatable now to populate your variables now
    HiddenField1.Value = pid;
    txt_proName.Text = pname;
    ddl_category.SelectedValue = pcid;
    txt_sdesc.Text = sdesc;
    txt_ldesc.Text = desc;
    txt_qnty.Text = qty;
    txt_price.Text = prce;
    txt_len.Text = len; 
}

GeneralRe: In 3 tier architecture , filling textboxes with values from database table Pin
Member 1418527516-Apr-19 3:51
memberMember 1418527516-Apr-19 3:51 
GeneralRe: In 3 tier architecture , filling textboxes with values from database table Pin
Vinod Jangle16-Apr-19 4:01
memberVinod Jangle16-Apr-19 4:01 
GeneralRe: In 3 tier architecture , filling textboxes with values from database table Pin
Member 1418527516-Apr-19 4:17
memberMember 1418527516-Apr-19 4:17 
GeneralRe: In 3 tier architecture , filling textboxes with values from database table Pin
Vinod Jangle16-Apr-19 5:26
memberVinod Jangle16-Apr-19 5:26 
GeneralRe: In 3 tier architecture , filling textboxes with values from database table Pin
Member 1418527516-Apr-19 6:04
memberMember 1418527516-Apr-19 6:04 
QuestionMake a title of the field goes over the field: asp MVC5 / Razor Pin
thabet idris12-Apr-19 0:15
memberthabet idris12-Apr-19 0:15 
AnswerRe: Make a title of the field goes over the field: asp MVC5 / Razor Pin
Vinod Jangle12-Apr-19 5:55
memberVinod Jangle12-Apr-19 5:55 
AnswerRe: Make a title of the field goes over the field: asp MVC5 / Razor Pin
Richard Deeming15-Apr-19 8:28
mveRichard Deeming15-Apr-19 8:28 
QuestionDisplay a message when Radio Button is not selected Pin
Member 128239698-Apr-19 4:58
memberMember 128239698-Apr-19 4:58 
AnswerRe: Display a message when Radio Button is not selected Pin
Vincent Maverick Durano10-Apr-19 11:03
mveVincent Maverick Durano10-Apr-19 11:03 
QuestionMembership section of VS2017 Web config Pin
Member 87616678-Apr-19 2:02
memberMember 87616678-Apr-19 2:02 
Questionwhy's the error not found namespace or class ? Pin
Member 24584676-Apr-19 20:43
memberMember 24584676-Apr-19 20:43 
AnswerRe: why's the error not found namespace or class ? Pin
OriginalGriff7-Apr-19 20:07
protectorOriginalGriff7-Apr-19 20:07 
GeneralRe: why's the error not found namespace or class ? Pin
Member 245846723-Apr-19 16:39
memberMember 245846723-Apr-19 16:39 
GeneralRe: why's the error not found namespace or class ? Pin
Mycroft Holmes23-Apr-19 19:18
memberMycroft Holmes23-Apr-19 19:18 
GeneralRe: why's the error not found namespace or class ? Pin
OriginalGriff23-Apr-19 20:03
protectorOriginalGriff23-Apr-19 20:03 
Question.Net Core 2.2.3 with Angular, preparing for Docker Container Deployment with MongoDB running in a container, all Linux going crazy Pin
jkirkerx5-Apr-19 12:27
professionaljkirkerx5-Apr-19 12:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.