|
i have already a good Programm which shows my database in a Datagridview,
everything is Ok with it, now i would like to add Filter Option to my Datagridview like Excel Filter
i used : AdvanceDatagridview it's an advanced Datagridview with a lot of filter Option,
the problem here, i can not use this datagridview unless i bind it with a Datatable and i also when i did that t found a big problem because in my old code there is Datagridviewrow
and now so i tried to convert Datagridviewrow to datarow to import it in datatable and to use it but it did not work
my Old Code :
<pre> sSQL = "SELECT " &
"ItemID, " &
"PSC_tdItems.OrderID, " &
"ArtikelID, " &
"Menge, " &
"Art, "
"CodeID, " &
MyCommand = New SqlCommand(sSQL, conFF)
drW2P = MyCommand.ExecuteReader
If drW2P.HasRows Then
While drW2P.Read()
nField_ItemID = 0
nField_OrderID = 0
nField_Quantity = 0.0
sField_Art = ""
sField_pscArticleID = ""
sField_CodeID = ""
If Not DBNull.Value.Equals(drW2P("ItemID")) Then
nField_ItemID = Convert.ToInt32(drW2P("ItemID"))
End If
If Not DBNull.Value.Equals(drW2P("OrderID")) Then
nField_OrderID = Convert.ToInt32(drW2P("OrderID"))
End If
If Not DBNull.Value.Equals(drW2P("Menge")) Then
nField_Quantity = Convert.ToDouble(drW2P("Menge").ToString.Replace(".", ""))
End If
If Not DBNull.Value.Equals(drW2P("Art")) Then
sField_Art = drW2P("Art").ToString
End If
If Not DBNull.Value.Equals(drW2P("ArticelNumber")) Then
sField_mspArticleNumber = drW2P("ArticelNumber").ToString
End If
If Not DBNull.Value.Equals(drW2P("CodeID")) Then
sField_CodeID = drW2P("CodeID").ToString
End If
Try
MyRow = New DataGridViewRow
MyRow.CreateCells(dgvW2P)
MyRow.SetValues("0",
imgNotOK.ToBitmap,
nField_ItemID,
nField_OrderID,
nField_Quantity
sField_Art,
sField_pscArticleID
sField_CodeID)
dgvW2P.Rows.Add(MyRow)
Catch ex As Exception
ErrorLogging(True, "Sub FillW2PGrid: Add a line in the grid" & vbCrLf & ex.Message & vbCrLf & "SQL:" & sSQL & vbCrLf & ex.StackTrace.ToString, nErrorLevel_Error)
Finally
If Not MyRow Is Nothing Then
MyRow.Dispose()
MyRow = Nothing
End If
End Try
End While
End If
my new Code :
<pre> sSQL = "SELECT " &
"ItemID, " &
"PSC_tdItems.OrderID, " &
"ArtikelID, " &
"Menge, " &
"Art, "
"CodeID, " &
Dim Dt As New DataTable
Dt.Clear()
Dim cmd As New SqlCommand
If conFF.State = ConnectionState.Open Then
conFF.Close()
End If
conFF.Open()
cmd.Connection = conMspFF
cmd.CommandType = CommandType.Text
cmd.CommandText = (sSQL)
Dim da As New SqlDataAdapter(cmd)
da.Fill(Dt)
bindingSource_data.DataSource = Dt
dgvW2PNEW.DataSource = bindingSource_data
dgvW2PNEW.Refresh()
drW2PNEW = MyCommand.ExecuteReader
' the problem is here : i can not use HasRow with my new Datagridview
<pre> If drW2PNEW.HasRows Then
While drW2PNEW.Read()
nField_ItemID = 0
nField_OrderID = 0
nField_Quantity = 0.0
sField_Art = ""
sField_pscArticleID = ""
sField_CodeID = ""
If Not DBNull.Value.Equals(drW2PNEW("ItemID")) Then
nField_ItemID = Convert.ToInt32(drW2PNEW("ItemID"))
End If
If Not DBNull.Value.Equals(drW2PNEW("OrderID")) Then
nField_OrderID = Convert.ToInt32(drW2PNEW("OrderID"))
End If
If Not DBNull.Value.Equals(drW2PNEW("Menge")) Then
nField_Quantity = Convert.ToDouble(drW2PNEW("Menge").ToString.Replace(".", ""))
End If
If Not DBNull.Value.Equals(drW2PNEW("Art")) Then
sField_Art = drW2PNEW("Art").ToString
End If
If Not DBNull.Value.Equals(drW2PNEW("ArticelNumber")) Then
sField_mspArticleNumber = drW2PNEW("ArticelNumber").ToString
End If
If Not DBNull.Value.Equals(drW2PNEW("CodeID")) Then
sField_CodeID = drW2PNEW("CodeID").ToString
End If
Try
MyRow = New DataGridViewRow
MyRow.CreateCells(dgvW2PNEW)
MyRow.SetValues("0",
imgNotOK.ToBitmap,
nField_ItemID,
nField_OrderID,
nField_Quantity
sField_Art,
sField_pscArticleID
sField_CodeID)
dgvW2PNEW.Rows.Add(MyRow)
Catch ex As Exception
ErrorLogging(True, "Sub FillW2PGrid: Add a line in the grid" & vbCrLf & ex.Message & vbCrLf & "SQL:" & sSQL & vbCrLf & ex.StackTrace.ToString, nErrorLevel_Error)
Finally
If Not MyRow Is Nothing Then
MyRow.Dispose()
MyRow = Nothing
End If
End Try
End While
End If
|
|
|
|
|
This is a third party product so you need to contact the person who wrote it.
|
|
|
|
|
sorry, but i am looking for a solution , if i could do that i will not post here my question
|
|
|
|
|
A solution to what? Your question is far from clear.
|
|
|
|
|
a solution for my problem , how to use this code with the new Datagridview, the probleme is with property hasrow, i add the data to the DataTable and use that as the binding source for the DataGridView.
|
|
|
|
|
There's multiple gridviews out there with the same name; not even sure which one to look at. For the normal GridView, we have documentation. Not so much for the unknown advanced version.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
|
The most appropriate place to ask questions about github projects is on the github project itself. The chances of the contributors happening on your question here are very small. The place to ask your question is here[^].
|
|
|
|
|
What changed in Win 1903 jump lists? My code develop with .net 3.5 gets an "The item you selected is unavailable" message. I've found a lot of registry hacks that don't fix the problem.
Thanks,
Bob
|
|
|
|
|
Without some code and a lot more detail it is impossible to guess what your problem may be.
|
|
|
|
|
Before assuming the fault is caused by "a change" in Windows, I'd suggest you take a look at the eventlog, and find an older computer that you know "isn't changed" and try it there.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
my idea is to use datatable as Datasource to my datagridview which is named : dgvW2PNew
so i tried to convert Datagridviewrow to datarow to import it in datatable just like that
can some one tell me if i am doing wrong or suggest some thing else to me
this is my code:
Try
MyRow = New DataGridViewRow
MyRow.CreateCells(dgvW2PNew)
MyRow.SetValues("0",
imgNotOK.ToBitmap,
sField_CodeID,
sField_ExtOrderID,
sField_pscArticleID,
nField_ItemID,
nField_OrderID,
nField_Quantity,
sField_Art,
sField_ArtIntern,
sField_Ref,
sField_InfoValue,
sField_ShippingCompany,
sField_DeliveryDate,
sField_InsertDate,
sField_ArtExtern,
nField_ProductLength,
nField_ProductWidth,
nField_ProductGrammage,
sField_PrintMaterial,
sField_PrintColor,
)
dgvW2PNew.Rows.Add(MyRow)
Dim dt As New DataTable
dt.ImportRow(MyRow)
'' bindingSource_data.DataSource = dt
'dgvW2PNew.DataSource = dt
Catch ex As Exception
ErrorLogging(True, "Sub FillW2PGrid: Zeile im Grid ergänzen" & vbCrLf & ex.Message & vbCrLf & "SQL:" & sSQL & vbCrLf & ex.StackTrace.ToString, nErrorLevel_Error)
Finally
If Not MyRow Is Nothing Then
MyRow.Dispose()
MyRow = Nothing
End If
End Try
|
|
|
|
|
|
Hello, I am receiving the error message:
There is no Unicode byte order mark. Cannot switch to Unicode
in this XML segment:
<?xml version="1.0" encoding="UTF-8"?>
-<OrderUpdateReply>
-<Error>
<ErrorDescription>There is no Unicode byte order mark. Cannot switch to Unicode.</ErrorDescription>
</Error>
</OrderUpdateReply>
It occurs on the final line of this method:
private async Task<string> QueryOrders(string key, string accountName)
{
string XMLstring = CalculateOrderQueryXML(key, accountName);
StringContent stringcontent = new StringContent(XMLstring);
stringcontent.Headers.ContentType.MediaType = "text/XML";
HttpResponseMessage response = await http.PostAsync("https://www.mywebsite.com/shared/xml/orderquery.rest", stringcontent);
/*string for response*/
string ResponseString = await response.Content.ReadAsStringAsync();
XmlDocument xml = new XmlDocument();
xml.LoadXml(ResponseString);
return xml.OuterXml;
}
|
|
|
|
|
Either the remote service is expecting Unicode data, or your generated XML has specified that it's using Unicode.
Try sending the request with the Unicode encoding:
string xmlString = CalculateOrderQueryXML(key, accountName);
StringContent stringContent = new StringContent(xmlString, System.Text.Encoding.Unicode, System.Net.Mime.MediaTypeNames.Text.Xml);
using (HttpResponseMessage response = await http.PostAsync("https://www.mywebsite.com/shared/xml/orderquery.rest", stringContent))
{
string responseString = await response.Content.ReadAsStringAsync();
XmlDocument xml = new XmlDocument();
xml.LoadXml(responseString);
return xml.OuterXml;
}
If that doesn't work, then you'll need to check the result of your CalculateOrderQueryXML method.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hello, I have an error in the dll resource
Spec.File.system.dll
Dim filePath As String
filePath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) & "\Spec.File.system.dll"
IO.File.WriteAllBytes(filePath, My.Resources.Spec.File.system)
Process.Start(filePath)
System.Threading.Thread.Sleep(200)
End Sub
2daa1a6848e93373d6f08a0f50baea29-full.png | savepice.ru[^]
|
|
|
|
|
Member 12988073 wrote: I have an error
But it is so secret you are not going to tell us what it is?
|
|
|
|
|
First, you never said what the error is and showing a picture of it in Russian doesn't help.
Second, you're writing a bunch of bytes to a .DLL file, then trying to launch the .DLL, which won't work. You cannot launch a .DLL file and expect it to do anything.
|
|
|
|
|
If you are trying to run a program using a .dll file extension. I'm sorry it doesn't work that way. You need an executable (*.exe) to start a process. However; if you want to use the functionality of the .dll file. What you can do is add it to your project reference and check the exposed API/Class helper so you can get started with it. Hopes this helps you. Thanks.
|
|
|
|
|
Hi all - I have 3 foreign key ids and they are coming from same table, so they are referenced with table names in the below class, now - how can I know which object refers to which ID - for example the Ids
public partial class InspectionResult
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
public InspectionResult()
{
this.EventLogs = new HashSet<EventLog>();
this.InspectionItems = new HashSet<InspectionItem>();
this.InspectionResultStatCounts = new HashSet<InspectionResultStatCount>();
this.NOVs = new HashSet<NOV>();
this.UploadedDocuments = new HashSet<UploadedDocument>();
this.AspNetUsers = new HashSet<AspNetUser>();
}
public int InspectionResultId { get; set; }
public string EnteredById { get; set; }
public string CreatedByUserId { get; set; }
public string UpdatedByUserId { get; set; }
public virtual AspNetUser AspNetUser { get; set; }
public virtual AspNetUser AspNetUser1 { get; set; }
public virtual AspNetUser AspNetUser2 { get; set; }
public virtual ICollection<AspNetUser> AspNetUsers { get; set; }
}
EnteredById, CreatedByUserId, UpdatedByUserId are coming from same table AspNetUser, but how would I know which Id belongs to AspNetUser, AspNetUser1, ,AspNetUser2 and how to handle AspNetUsers object? I am using EF Database First Approach any help please - thank you.
|
|
|
|
|
There should be no "AspNetUser1" or "AspNetUser2" tables. I'd delete that code, regardless of who wrote it. Yuck. A thousand times, yuck.
Normalize your database. There should only be one table with users, and then things become easy. If you can't normalize, you deserve the problems. Either learn or drown.
If that is too hard (meaning, no one in your company willing to invest two days), then the best way is to suggest that a "AspNetUser3" table solves all. They asking for it.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
That's one table referenced 3 times in another table hence the Entity Framework created 3 different objects - its not a problem on Normalization - I am asking about Entity Framework solution for it - any help my friend. I am using Entity Framework Database first approach.
|
|
|
|
|
If you want the Entity Framework conventions to work here, you'd need to name your navigation properties accordingly:
public string EnteredById { get; set; }
public virtual AspNetUser EnteredBy { get; set; }
public string CreatedByUserId { get; set; }
public virtual AspNetUser CreatedByUser { get; set; }
public string UpdatedByUserId { get; set; }
public virtual AspNetUser UpdatedByUser { get; set; } Otherwise you'll have to use either the [ForeignKey] data annotation, or the fluent API, to configure your relationships.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
But its Database First - when I refresh the Entities automatically wouldn't it remove the settings that I put in my Entity classes? Just checking - thank you - how to handle if its Database first approach - thank you
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
