way to put linkbutton into tablecell, asp.net

2022-05-04 10:45 ikzz imported from Stackoverflow

Here is the part of a code which builds DB from SQL query, but I need to put extra cell for LinkButton.

for (int j = 0; j < numrows; j++)
{
    TableRow row = new TableRow();

    for (int i = 0; i < numcols; i++)
    {
        TableCell cell = new TableCell();
        string textContent;

        textContent = subjects.Rows[j][i].ToString();
        cell.Text = textContent;

        row.Cells.Add(cell);
    }

    TableCell cell1 = new TableCell();

    LinkButton button = new LinkButton();
    button.Text = "look";
    button.Click += new EventHandler(submit_Click2);

    cell1. = button;
    row.Cells.Add(cell1);
    table.Rows.Add(row);
}

The question is that I don't know what do to with this part of a code where I put button into cell, I couldn't find a way to do it. Is it possible to do it without GridView, because I can't use it?

TableCell cell1 = new TableCell();

LinkButton button = new LinkButton();
button.Text = "look";
button.Click += new EventHandler(submit_Click2);

cell1. = button;

1 answer

answered 2022-05-04 12:21 VDWWD

Here you go, a simple example. But remember to not add the table to the page within IsPostBack

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        //do not add dynamic controls like the linkbutton in the table in  "IsPostBack"
    }

    //to generate some random data
    var random = new Random();

    //number of rows and cells
    var rowCount = random.Next(5, 25);
    var cellCount = random.Next(3, 10);

    //create a new table
    var table = new Table()
    {
        CssClass = "table table-striped"
    };

    //add the rows
    for (int i = 0; i < rowCount; i++)
    {
        var row = new TableRow();

        //add the cells
        for (int j = 0; j < cellCount; j++)
        {
            //create a new cell
            var cell = new TableCell();

            //if the cell is not the last add content, otherwise add the linkbutton
            if (j < cellCount - 1)
            {
                cell.Text = "CellValue " + random.Next(1000, 100000).ToString();
            }
            else
            {
                //create a new linkbutton
                var lb = new LinkButton()
                {
                    Text = "LinkButton"
                };

                //add the click event handler
                lb.Click += new EventHandler(LinkButton_Click);

                //add the linkbutton to the cell
                cell.Controls.Add(lb);
            }

            //add the cell to the row
            row.Cells.Add(cell);
        }

        //add the row to the table
        table.Rows.Add(row);
    }

    //add the table to the page
    PlaceHolder1.Controls.Add(table);
}

See also questions close to this topic

C# - Adding condition to func results in stack overflow exception
I have a func as part of specification class which sorts the given iqueryable
```
Func<IQueryable<T>, IOrderedQueryable<T>>? Sort { get; set; }
```
When i add more than one condition to the func like below , it results in stack overflow exception.
```
spec.OrderBy(sc => sc.Case.EndTime).OrderBy(sc => sc.Case.StartTime);
```
The OrderBy method is implemented like this
```
public ISpecification<T> OrderBy<TProperty>(Expression<Func<T, TProperty>> property)
    {
        _ = Sort == null ? Sort = items => items.OrderBy(property) : Sort = items => Sort(items).ThenBy(property);
        return this;
    }
```
Chaining or using separate lines doesn't make a difference.

This problem gets resolved if I assign a new instance of the specification and set it's func, but i don't want to be assigning to a new instance everytime. Please suggest what am i missing here and how to reuse the same instance (if possible).

How to projection fields for a dictionary (C#, MongdoDB)

I am trying my luck here, I have a model which is like the following

public class RowData : BaseBsonDefinition
{
.
  [BsonExtraElements]
  [BsonDictionaryOptions(DictionaryRepresentation.ArrayOfDocuments)]
  public Dictionary<string, object> Rows { get; set; } = new(StringComparer.OrdinalIgnoreCase);
.
}

In result, the schema in the MongoDB looks like

{
"_id": {
    "$binary": {
      "base64": "HiuI1sgyT0OZmcgGUit2dw==",
      "subType": "03"
    }
  },
  "c1": "AAA",
  "c8": "Fully Vac",
  "c10": "",
}

Those c1, c8 and c10 fields are keys from the dictionary, my question is how to dynamic project those fields?

I tried

Builders<RowData>.Projection.Exclude(p => "c1")

It seems the MongoDB driver can not handle a value directly.

Anyone could point me in the correct direction?

Thanks,

How do I add new DataSource to an already Databinded CheckBoxList

i'm building a web form that show Database's item(Tables, Rows, FK,...)

I have a CheckBoxList of Tables (chkListTable) which will show a new CheckBoxList of Rows (chkListRow) everytime I SelectedIndexChanged from chkListTable. The problem is i can show the items from chkListTable with 1 selected item. But i don't know how to show chkListRow if multiple item from chkListTable are selected.

Here are my codes:

aspx:

<div>
             <asp:Label ID="Label2" runat="server" Text="Table: "></asp:Label>
             <asp:CheckBoxList ID="chkListTable" runat="server"
                 DataTextField="name"
                 DataValueFeild="name"
                 AutoPostBack="true"
                 OnSelectedIndexChanged="chkListTable_SelectedIndexChanged">
             </asp:CheckBoxList>
        </div>
        <div>
             <asp:CheckBoxList ID="chkListRow" runat="server"
             DataTextField="COLUMN_NAME"
             DataValueField="COLUMN_NAME"
             RepeatDirection="Horizontal">
             </asp:CheckBoxList>
        </div>

aspx.cs:

protected void chkListTable_SelectedIndexChanged(object sender, EventArgs e)
    {
        tableName.Clear();
        
        foreach (ListItem item in chkListTable.Items)
        {
            if(item.Selected)
            {
                tableName.Add(item.Text.Trim());
            }    
        }

        for(int i = 0; i < tableName.Count; i++)
        {
            String query = "USE " + dbname +
                " SELECT * FROM information_schema.columns" +
                " WHERE table_name = '" + tableName[i] + "'" +
                " AND COLUMN_NAME != 'rowguid'";
            chkListRow.DataSource = Program.ExecSqlDataReader(query);
            chkListRow.DataBind(); 
            Program.conn.Close();
        }
    }

Program.cs:

public static bool Connect()
    {
        if (Program.conn != null && Program.conn.State == ConnectionState.Open)
            Program.conn.Close();
        try
        {
            Program.conn.ConnectionString = Program.constr;

            Program.conn.Open();

            return true;
        }

        catch (Exception e)
        {
            return false;
        }
    }

    public static SqlDataReader ExecSqlDataReader(String query)
    {
        SqlDataReader myreader;
        SqlCommand sqlcmd = new SqlCommand(query, Program.conn);
        sqlcmd.CommandType = CommandType.Text;
        if (Program.conn.State == ConnectionState.Closed) Program.conn.Open();
        try
        {
            myreader = sqlcmd.ExecuteReader();
            return myreader;
            myreader.Close();
        }
        catch (SqlException ex)
        {
            Program.conn.Close();
            return null;
        }
    }

I want my display to be like this:

[x]Table1 [x]Table2 [ ]Table3
[ ]Row1(Table1) [ ]Row2(Table1) [ ]Row3(Table1)
[ ]Row1(Table2) [ ]Row2(Table2)

Writing multithreaded code to generate incremental index

I want to write a code in following scenario : we want to design an invoice generator.this invoice generator also generates an incremental invoice no .Also note that for some reasons we dont use something like sql Auto Increment here and we want to use C# (I wrote the increment logic). since several users can send requests at a time it means that we dont have to give the same invoice no to them (I used lock for it and I wrote it).

Now i have written increment logic. and i take care of multiple users requests with lock . and I wrote CRUD for mongodb database.

My problem is that my increent logic is naive. each time i find maximum and i increment by one which is not scalable. and another problem is that when we delete a record we don't want the invoice no to be repeated and since we find max if the deleted record had the max value then the invoice no would be duplicate and this is something we don't want to have.

I really don't know how to handle the problem. specially in case of deletion should i store max values in a file or should i change increment logic completely?

i appreciate any help

Scraping .aspx page with Python yields 404

I'm a web-scraping beginner and am trying to scrape this webpage: https://profiles.doe.mass.edu/statereport/ap.aspx

I'd like to be able to put in some settings at the top (like District, 2020-2021, Computer Science A, Female) and then download the resulting data for those settings.

Here's the code I'm currently using:

import requests
from bs4 import BeautifulSoup

url = 'https://profiles.doe.mass.edu/statereport/ap.aspx'
with requests.Session() as s:
    s.headers['User-Agent'] = "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:100.0) Gecko/20100101 Firefox/100.0"
    r = s.get('https://profiles.doe.mass.edu/statereport/ap.aspx')
    soup = BeautifulSoup(r.text,"lxml")
    data = {i['name']:i.get('value','') for i in soup.select('input[name]')}
    
    
    data["ctl00$ContentPlaceHolder1$ddReportType"]="DISTRICT",
    data["ctl00$ContentPlaceHolder1$ddYear"]="2021",
    data["ctl00$ContentPlaceHolder1$ddSubject"]="COMSCA",
    data["ctl00$ContentPlaceHolder1$ddStudentGroup"]="F",
    
    p = s.post(url,data=data)

When I print out p.text, I get a page with title '\t404 - Page Not Found\r\n' and message

<h2>We are unable to locate information at: <br /><br '
 '/>http://profiles.doe.mass.edu:80/statereport/ap.aspxp?ASP.NET_SessionId=bxfgao54wru50zl5tkmfml00</h2>\r\n'

Here's what data looks like before I modify it:

{'__EVENTVALIDATION': '/wEdAFXz4796FFICjJ1Xc5ZOd9SwSHUlrrW+2y3gXxnnQf/b23Vhtt4oQyaVxTPpLLu5SKjKYgCipfSrKpW6jkHllWSEpW6/zTHqyc3IGH3Y0p/oA6xdsl0Dt4O8D2I0RxEvXEWFWVOnvCipZArmSoAj/6Nog6zUh+Jhjqd1LNep6GtJczTu236xw2xaJFSzyG+xo1ygDunu7BCYVmh+LuKcW56TG5L0jGOqySgRaEMolHMgR0Wo68k/uWImXPWE+YrUtgDXkgqzsktuw0QHVZv7mSDJ31NaBb64Fs9ARJ5Argo+FxJW/LIaGGeAYoDphL88oao07IP77wrmH6t1R4d88C8ImDHG9DY3sCDemvzhV+wJcnU4a5qVvRziPyzqDWnj3tqRclGoSw0VvVK9w+C3/577Gx5gqF21UsZuYzfP4emcqvJ7ckTiBk7CpZkjUjM6Z9XchlxNjWi1LkzyZ8QMP0MaNCP4CVYJfndopwFzJC7kI3W106YIA/xglzXrSdmq6/MDUCczeqIsmRQGyTOkQFH724RllsbZyHoPHYvoSAJilrMQf6BUERVN4ojysx3fz5qZhZE7DWaJAC882mXz4mEtcevFrLwuVPD7iB2v2mlWoK0S5Chw4WavlmHC+9BRhT36jtBzSPRROlXuc6P9YehFJOmpQXqlVil7C9OylT4Kz5tYzrX9JVWEpeWULgo9Evm+ipJZOKY2YnC41xTK/MbZFxsIxqwHA3IuS10Q5laFojoB+e+FDCqazV9MvcHllsPv2TK3N1oNHA8ODKnEABoLdRgumrTLDF8Lh+k+Y4EROoHhBaO3aMppAI52v3ajRcCFET22jbEm/5+P2TG2dhPhYgtZ8M/e/AoXht29ixVQ1ReO/6bhLIM+i48RTmcl76n1mNjfimB8r3irXQGYIEqCkXlUHZ/SNlRYyx3obJ6E/eljlPveWNidFHOaj+FznOh264qDkMm7fF78WBO2v0x+or1WGijWDdQtRy9WRKXchYxUchmBlYm15YbBfMrIB7+77NJV+M6uIVVnCyiDRGj+oPXcTYxqSUCLrOMQyzYKJeu8/hWD0gOdKeoYUdUUJq4idIk+bLYy76sI/N2aK+aXZo/JPQ+23gTHzIlyi4Io7O6kXaULPs8rfo8hpkH1qXyKb/rP2VJBNWgyp8jOMx9px+m4/e2Iecd86E4eN4Rk6OIiwqGp+dMdgntXu5ruRHb1awPlVmDw92dL1P0b0XxJW7EGfMzyssMDhs1VT6K6iMUTHbuXkNGaEG1dP1h4ktnCwGqDLVutU6UuzT6i4nfqnvFjGK9+7Ze8qWIl8SYyhmvzmgpLjdMuF9CYMQ2Aa79HXLKFACsSSm0dyiU1/ZGyII2Fvga9o+nVV1jZam3LkcAPaXEKwEyJXfN/DA7P4nFAaQ+QP+2bSgrcw+/dw+86OhPyG88qyJwqZODEXE1WB5zSOUywGb1/Xed7wq9WoRs6v8rAK5c/2iH7YLiJ4mUVDo+7WCKrzO5+Hsyah3frMKbheY1acRmSVUzRgCnTx7jvcLGR9Jbt6TredqZaWZBrDFcntdg7EHd7imK5PqjUld3iCVjdyO+yLKUkMKiFD85G3vEferg/Q/TtfVBqeTU0ohP9d+CsKOmV/dxVYWEtBcfa9KiN6j4N8pP7+3iUOhajojZ8jV98kxT0zPZlzkpqI4SwR6Ys8d2RjIi5K+oQul4pL5u+zZvX0lsLP9Jl7FeVTfBvST67T6ohz8dl9gBfmmbwnT23SyuFSUGd6ZGaKE+9kKYmuImW7w3ePs7C70yDWHpIpxP/IJ4GHb36LWto2g3Ld3goCQ4fXPu7C4iTiN6b5WUSlJJsWGF4eQkJue8=',
 '__VIEWSTATE': '/wEPDwUKLTM0NzY4OTQ4NmRkDwwPzTpuna+yxVhQxpRF4n2+zYKQtotwRPqzuCkRvyU=',
 '__VIEWSTATEGENERATOR': '2B6F8D71',
 'ctl00$ContentPlaceHolder1$btnViewReport': 'View Report',
 'ctl00$ContentPlaceHolder1$hfExport': 'ViewReport',
 'leftNavId': '11241',
 'quickSearchValue': '',
 'runQuickSearch': 'Y',
 'searchType': 'QUICK',
 'searchtext': ''}

Following suggestions from similar questions, I've tried playing around with the parameters, editing data in various ways (to emulate the POST request that I see in my browser when I navigate the site myself), and specifying an ASP.NET_SessionId, but to no avail.

How can I access the information from this website?

Getting "undefined" on response.d MVC ASP.NET Core Ajax

I´m trying to create a datatable using Ajax, but before creating and filling the data table with the ajax response, on success I send an alert with "response.d" it returns undefined and thats why im not filling the data table.

Script

<script>
        $(document).ready(function () {
            $('#tabHistorialTrabajos').click(function () {
                $.ajax({
                    type: "GET",
                    url: "/Monitoreo/GetData",
                    data: '{}',
                    contentType: "application/json; charset=utf-8",
                    dataType: "json",
                    //success: OnSuccess,
                    success: function (response) {
                        alert(response.d);
                    },
                    failure: function (response) {
                        alert(response.d);
                    },
                    error: function (response) {
                        alert(response.d);
                    }
                });
            });
        });

        function OnSuccess(response) {
            $("datatableTrabajos").DataTable(
                {
                    blengthchange: true,
                    lengthmenu: [[5, 10, -1], [5, 10, "all"]],
                    bfilter: true,
                    bsort: true,
                    bpaginate: true,
                    data: response.d,
                    columns: [{ 'data': 'idTrabajo' },
                        { 'data': 'idTurnoXMaquina' },
                        { 'data': 'parte' },
                        { 'data': 'cliente' },
                        { 'data': 'cantidadPedido' },
                        { 'data': 'cantidadMerma' },
                        { 'data': 'cantidadTarimas' },
                        { 'data': 'fechaInicio' },
                        { 'data': 'fechaFin' },
                        { 'data': 'cantidadFabricado' },
                        { 'data': 'tiempoMuerto' },
                        { 'data': 'velocidad' },
                        { 'data': 'fabricado' }
                    ]
                });
        };
    </script>

Controller (returns a JSON)

public string GetData()
        {
            ServiciosMenu serviciosMenu = new ServiciosMenu();
            List<CorridaModel> listadoTrabajosXMaquina = serviciosMenu.GetHistorialTrabajosXMaquina(4);
            string JsonResult = JsonConvert.SerializeObject(listadoTrabajosXMaquina);
            return JsonResult;
        }

R datatable rotate header not aligning

I am trying to rotate the header for a datatable. I was able to rotate the header but the rotated header is not aligning with the columns. This is what I have now:

I referenced this for my code : header direction in shiny data table

Here is my code:

datatable(df, rownames = F,class = c("compact"),options = list(paging = F, autoWidth = T,searching= FALSE,
                                        scrollX=T,
                                        initComplete = JS("function(settings, json) {$(this.api().table().header()).css({'font-size' : '12px'});}"),
                                        headerCallback = JS(
                                            "function(thead, data, start, end, display){
                                            var $ths = $(thead).find('th');
                                            $ths.css({'vertical-align': 'bottom', 'white-space': 'nowrap'});
                                            var betterCells = [];
                                            $ths.each(function(){
                                              var cell = $(this);
                                              var newDiv = $('<div>', {height: 'auto', width: cell.height()});
                                              var newInnerDiv = $('<div>', {text: cell.text()});
                                              newDiv.css({margin: 'auto'});
                                              newInnerDiv.css({
                                                transform: 'rotate(220deg)',
                                                'writing-mode': 'tb-rl',
                                                'white-space': 'nowrap'
                                              });
                                              newDiv.append(newInnerDiv);
                                              betterCells.push(newDiv);
                                            });
                                            $ths.each(function(i){
                                              $(this).html(betterCells[i]);
                                            });
                                          }"
                                        ))) %>% 
  formatStyle(columns = c(1:19), `font-size` = '12px')

DATA:

structure(list(diag_category_name = structure(1:18, .Label = c("AIDS", 
"Any malignancy", "Cerebrovascular disease", "Chronic pulmonary disease", 
"Congestive heart failure", "Dementia", "Diabetes (mild to moderate)", 
"Diabetes with chronic complications", "Hemoplegia or paralegia", 
"Metastatic solid tumor", "Mild liver disease", "Moderate to severe liver disease", 
"Myocardial infarction", "No Charlson Comorbidity", "Peptic ulcer disease", 
"Peripheral vascular disease", "Renal disease", "Rheumatologic disease"
), class = "factor"), AIDS = c(20L, 6L, 3L, 5L, 1L, NA, NA, NA, 
1L, 14L, 2L, NA, 1L, NA, NA, 3L, 5L, NA), `Any malignancy` = c(6L, 
1051L, 108L, 209L, 106L, 34L, 130L, 158L, 14L, NA, 92L, 10L, 
86L, NA, 37L, 190L, 161L, 32L), `Cerebrovascular disease` = c(3L, 
108L, 421L, 122L, 105L, 44L, 47L, 94L, 35L, 303L, 35L, 7L, 67L, 
NA, 23L, 165L, 111L, 15L), `Chronic pulmonary disease` = c(5L, 
209L, 122L, 726L, 146L, 34L, 80L, 152L, 23L, 505L, 84L, 15L, 
90L, NA, 43L, 234L, 173L, 31L), `Congestive heart failure` = c(1L, 
106L, 105L, 146L, 381L, 27L, 37L, 124L, 15L, 269L, 43L, 3L, 121L, 
NA, 18L, 166L, 160L, 16L), Dementia = c(NA, 34L, 44L, 34L, 27L, 
109L, 11L, 32L, 5L, 74L, 5L, 1L, 26L, NA, 3L, 44L, 44L, 3L), 
    `Diabetes (mild to moderate)` = c(NA, 130L, 47L, 80L, 37L, 
    11L, 475L, NA, 8L, 335L, 58L, 9L, 36L, NA, 17L, 79L, 45L, 
    12L), `Diabetes with chronic complications` = c(NA, 158L, 
    94L, 152L, 124L, 32L, NA, 573L, 18L, 400L, 75L, 9L, 83L, 
    NA, 27L, 173L, 229L, 16L), `Hemoplegia or paralegia` = c(1L, 
    14L, 35L, 23L, 15L, 5L, 8L, 18L, 63L, 45L, 4L, NA, 13L, NA, 
    4L, 21L, 14L, 3L), `Metastatic solid tumor` = c(14L, NA, 
    303L, 505L, 269L, 74L, 335L, 400L, 45L, 2778L, 264L, 27L, 
    186L, NA, 79L, 492L, 455L, 68L), `Mild liver disease` = c(2L, 
    92L, 35L, 84L, 43L, 5L, 58L, 75L, 4L, 264L, 362L, NA, 29L, 
    NA, 22L, 73L, 70L, 8L), `Moderate to severe liver disease` = c(NA, 
    10L, 7L, 15L, 3L, 1L, 9L, 9L, NA, 27L, NA, 38L, 3L, NA, 6L, 
    11L, 10L, 1L), `Myocardial infarction` = c(1L, 86L, 67L, 
    90L, 121L, 26L, 36L, 83L, 13L, 186L, 29L, 3L, 277L, NA, 20L, 
    99L, 86L, 11L), `No Charlson Comorbidity` = c(NA, NA, NA, 
    NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 49L, NA, NA, NA, 
    NA), `Peptic ulcer disease` = c(NA, 37L, 23L, 43L, 18L, 3L, 
    17L, 27L, 4L, 79L, 22L, 6L, 20L, NA, 118L, 33L, 31L, 4L), 
    `Peripheral vascular disease` = c(3L, 190L, 165L, 234L, 166L, 
    44L, 79L, 173L, 21L, 492L, 73L, 11L, 99L, NA, 33L, 693L, 
    197L, 22L), `Renal disease` = c(5L, 161L, 111L, 173L, 160L, 
    44L, 45L, 229L, 14L, 455L, 70L, 10L, 86L, NA, 31L, 197L, 
    633L, 24L), `Rheumatologic disease` = c(NA, 32L, 15L, 31L, 
    16L, 3L, 12L, 16L, 3L, 68L, 8L, 1L, 11L, NA, 4L, 22L, 24L, 
    106L)), row.names = c(NA, -18L), class = c("data.table", 
"data.frame"), .internal.selfref = <pointer: 0x5638d466ed90>, sorted = "diag_category_name")

Change Datatables interface language with angular ngx-translate

I'm working with ngx-translate in angular 4. I want to change data tables interface language. For this I have create a .ts file:

export class LanguageApp {
    public static it_datatables = {
        emptyTable: "it",
        //// ...... ////

    }
    public static eng_datatables = {
        emptyTable: "eng",
        //// .... ////
    }
}

in the component where the table will appear, I put this code inside ngOnInit I added:

    if(this.translateService.currentLang === 'Italiano' ){
        this.dtOptions = {
            language: LanguageApp.it_datatables
        };
    }else{
        this.dtOptions = {
            language: LanguageApp.eng_datatables
        };
    }
    this.translateService.onLangChange.subscribe((event: LangChangeEvent) => {
        console.log(event.lang);
        if(event.lang === 'English'){
            this.dtOptions = {
                language: LanguageApp.it_datatables
            };
        } else {
            this.dtOptions = {
                language: LanguageApp.eng_datatables
            };
        }
      });

The translation is done correctly only when you open the component. When I change the language it does not work. Please can you advise me how to translate automatically when the language changes ?

Related questions

way to put linkbutton into tablecell, asp.net

1 answer

See also questions close to this topic