'=== Radgrid "Suchresultate" ==============================================================
Dim connString As String
Dim cmdString As String
connString = ConfigurationManager.ConnectionStrings("BwaConnectionString").ConnectionString
cmdString = "SELECT [ArtikelID], [Artikelnummer], [Bezeichnung], [Preis], [Text], [Bild], [Warengruppe], [Einheit] FROM [Artikel] WHERE (([Artikelnummer] LIKE '%' + @Artikelnummer + '%') OR ([Bezeichnung] LIKE '%' + @Bezeichnung + '%') OR ([Text] LIKE '%' + @Text + '%'))"
Dim conn As SqlConnection
Dim cmd As New SqlCommand
conn = New SqlConnection(connString)
cmd = New SqlCommand(cmdString, conn)
conn.Open()
Dim da As New SqlDataAdapter
'--- Querystring "Suche" in String speichern ----------------------------------------------
Dim str_Suche As String
str_Suche = Request.QueryString("Suche")
'--- SqlParameter definieren --------------------------------------------------------------
'--- WICHTIG: Das Command und Connection Objekt muß schon initialisiert und geöffnet sein -
'--- Sonst Fehler bei den SqlParametern!!! ------------------------------------------------
With cmd.Parameters
.Add(New SqlParameter("@Artikelnummer", str_Suche))
.Add(New SqlParameter("@Bezeichnung", str_Suche))
.Add(New SqlParameter("@Text", str_Suche))
End With
'--- SqlParameter definieren E N D E -----------------------------------------------------
'--- DataReader anlegen und zuweisen als Datasource
Dim dr_Suchresultate As SqlDataReader
dr_Suchresultate = cmd.ExecuteReader(CommandBehavior.CloseConnection)
Dim dt_Suchresultate As New DataTable
dt_Suchresultate.Load(dr_Suchresultate)
RadGrid_Suchresultate.DataSource = dt_Suchresultate
RadGrid_Suchresultate.DataBind()
'------------------------------------------------------------------------------------------
'=== Radgrid "Suchresultate" E N D E ======================================================
Can you please give me a hint what to do?
Thanks in advance for your help
Best regards
Thomas
| protected void rgvHealthInspList_ItemCommand(object sender, GridCommandEventArgs e) |
| { |
| if (e.CommandName == "InsertNest") |
| { |
| GridTableView tblView = e.Item.OwnerTableView as GridTableView; |
| GridItem[] nTablesViews = tblView.GetItems(GridItemType.NestedView); |
| GridNestedViewItem nTableView = nTablesViews[0] as GridNestedViewItem; |
| GridTableView nTable = nTableView.NestedTableViews[0]; |
| //Attempt 1 |
| //nTableView.FireCommandEvent("InitInsert", string.Empty); |
| //Attempt 2 |
| //nTable.IsItemInserted = true; |
| //nTable.Rebind(); |
| //Attempt 3 |
| //nTable.InsertItem(); |
| //Attempt a whole bunch of other trys...... :-( |
| //GridEditableItem nItem = nTable.GetInsertItem(); |
| //nItem.FireCommandEvent("InitInsert", nItem.DataItem); |
| //nTableView.FireCommandEvent("InitInsert", nTable); |
| //nTable.FireCommandEvent("InitInsert", nTable); |
| } |
| } |

| <div class="ao-boxWithTabsContainer ao-ApplicationsBox"> |
| <div class="ao-boxWhiteFixHeightTitle"> |
| <div> |
| applications</div> |
| </div> |
| <div class="linkAppCountry" id="div1"> |
| <a href="http://www.google.fr" class="ao-boxWithTabsCountryLink" id="A1" target="_self"> |
| Title not set</a> <a href="http://www.google.fr" class="ao-boxWithTabsGroupLink" |
| id="A2" target="_self">Group</a> |
| </div> |
| <div class="ao-boxContent ao-box85" id="div2"> |
| <ul> |
| <li><a href="#">Premiere bullet</a> </li> |
| <li><a href="#">Seconde bullet</a> </li> |
| <li><a href="#">Troisieme bullet</a> </li> |
| <li><a href="#">Quatrieme bullet</a> </li> |
| <li><a href="#">Cinquieme bullet</a> </li> |
| </ul> |
| </div> |
| <div class="ao-boxContent ao-box85" id="div3" style="display: none;"> |
| </div> |
| </div> |
| <div class="ao-boxWithTabsContainer ao-ApplicationsBox"> |
| <div class="ao-boxWhiteFixHeightTitle"> |
| <div> |
| applications</div> |
| </div> |
| <div class="linkAppCountry" id="div1"> |
| Title not set <a href="http://www.google.fr" class="ao-boxWithTabsGroupLink" id="A2" |
| target="_self">Group</a> |
| </div> |
| <div class="ao-boxContent ao-box85" id="div2"> |
| <ul> |
| <li><a href="#">Premiere bullet</a> </li> |
| <li><a href="#">Seconde bullet</a> </li> |
| <li><a href="#">Troisieme bullet</a> </li> |
| <li><a href="#">Quatrieme bullet</a> </li> |
| <li><a href="#">Cinquieme bullet</a> </li> |
| </ul> |
| </div> |
| <div class="ao-boxContent ao-box85" id="div3" style="display: none;"> |
| </div> |
| </div> |

| <pages clientIDMode="Static"> |
An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
|
[ArgumentException: Value cannot be null or empty. |
