I am using a sql server database and i am storing the time value in the datetime variable. I am developing a booking system application in vb.net. When I want to view already made bookings using datagridview and by implementing dataadapter and dataset...When the table is shown in the datagridview I want custom column names to be shown so tell me that how can i use alias in the query given in datadapter initialization part?
View 1 Replies
I am using a databound datagridview control. I created a custom query to fill the grid with which includes joins and using alias names in the sql query for the joined fields. Here is the query I am using:
SELECT Events.[Date], Events.[Time], Contacts.LastName AS Lastname, Contacts.FirstName AS Firstname
FROM (Events INNER JOIN
Contacts ON Events.ContactID = Contacts.ContactID)
The datagrid views fine using the columns that are in the events table. I want to be able to view the aliased columns from the contacts table in the datagridview as well.
How can I display the joined columns in the datagridview? Maybe there is a better way to do this? Maybe this is not enough information for a resolution.
I am using a query in vb.net, database is Access. I need alias of query like sql but the query return me column alias and also ' '
SELECT COLUMN1 AS 'FIRST NAME'
I expect the result to be a field called FIRST NAME but it returns the string "FIRST NAME". Is there is any way if return me the field FIRST NAME instead of "FIRST NAME".
I have access Query have more than one table. I want to insert into it. I cannot insert into it by CommandBuilder coz CommandBuilder for one table only so how can I do that using DataAdapter with dataset.
View 6 RepliesIs there any difference in the
1) If I insert a row into a sql table using insert query and
2) If I fill a datatable in dataset and add a row to it and again use the dataadapter.Update method for inserting this row.
This is how I update a table using DataAdapter and DataSet in VB using SQL Server[code]...
I know that the Fill method does not make sense in case of an INSERT statement, but I am new to this technology and the above statement does the job and updates the table w/o problems. My question is this: If there was an error (say a duplicate key error) how would I know this in my application? Should I be putting the above code in a try/catch block?
Also, if there is a "proper" method for running INSERT statements using a DataAdapter/DataSet combination that does not use the Fill method, please indicate that as well.
I have an enum in one module that's used in another that has a long name:
Public Enum Enumwithaverylongname
foo
bar
end Enum
When I use it, I'd like to alias it to a shorter name like:
f.foo
instead of
Enumwithaverylongname.foo
Can I do that?
Here's my SQL query:
SELECT EmployeeID, EmployeeLastName + ', ' + EmployeeFirstName AS Name
FROM employees
ORDER BY Name
How can I go about doing the something in LINQ to SQL?
I have an object and I iterate over object's properties. Foreach property, i append it as a column to a listview.
In my object, some properties doesn't have accents. But in portuguese, they do. For example: "Endereco" property must be "Endereo".
I need an away to create an alias to the properties.
I'm writing custom code in VS2005 Reports (SSRS / Report Builder). The code is working fine, but I have to make absolute references to assembly classes. For instance:For Each m As System.Text.RegularExpressions.Match In ...Is there any way to alias the reference to System.Text.RegularExpressions.Match, so that I can reuse it in a concise manner? I know in PHP, you'd do it like this:
use MyNamespace\MySubNamespace\MyClassVerboseName as MyClass
[...]
MyClass->MyMethod();
[code]......
doesn't really matter? low priority.
[Code]...
I am assigning the class object to grid's data source. And grid displaying all the properties of class with values. But i do not want to display the original name of properties of class. Is there any way to provide set alias name to property to display in grid?
I know that it can be possible by setting the grid's column caption. But i want to do it at class level or by other way instead of processing on Grid. Is there any attribute that set alias name to property?
I have some VB6 code that I am converting to VB.net and came across this section
Declare Function TmSendByLen Lib "tmctl.dll" Alias "TmSendByLength"(ByVal id As Integer, ByRef msg As Any, ByVal blen As Integer) As Integer
'snip'
[code]....
I have not come across the Alias term before but I can guess what it does. What I am unsure of is the reasoning behind overloading the alias. If that is what is happening.I need to create overloads for the TmSendByLen function as the 'As Any' is not supported in VB.net so I am not sure if I should just remove the alias or if I should leave it in place.
Using .NET (VB or C#), how can I add an e-mail alias to a user in Active Directory? I have written code to change the format of our usernames from "first_last" to "first.last.country" and I need to update the e-mail addresses as well. Our solution is to add an alias e-mail to the users in exchange, but I don't know how I can do this using .NET.
View 1 RepliesIn Reporting Service, I need to have a vertical, starting at bottom, bottom-to-top, horizontally middle aligned text.The only way to do this is to create an image in code, and set this image into the title column.See the code below.Basically, it works fine, just that the anti-alias quality is pretty crappy.Is there anything I can do to improve it ?The vertical text is somehow pale, and not full black, and also there is smearing all around the text, in the background color.As well as it appears bolder than the text on the left, but both have format arial, size 8, bold I've tried all other values of System.Drawing.Text.TextRenderingHint.*, as well as no anti-alias at all but the current one seems to be the least crappy.I've also tried to change the image format, to no avail:
Function LoadImage2(ByVal sImageText As String, ByVal sImageTextMax As String) As System.Drawing.Image
sImageTextMax = sImageTextMax.PadRight(15)
Dim iFontSize As Integer = 8 '//Change this as needed
[code]....
How might one go about aliasing a type in VB.NET or C# such that when the alias is used as an argument type in a function, accidentally using the not aliased type is an error?
i.e.
Imports AccessSpecifier = System.String
Module Accessors
Delegate Function IoOper(ByRef strm As System.IO.Stream) As Action
[code]....
Overall, I'm wanting the IDE to force me to know what I'm doing if I'm throwing Ints around to mean Flags, or States and Strings around to mean Names, Propertys and Records.
I'm trying to get the Alias of the logged in user (Active Directory/LDAP environment/Exchange) .
View 8 RepliesI'm using Redumption to send a mail using VB.NET, I've stored a file with an unique name exg.c:docs123.pdf which I'm supposed to attach to the mail with a different name "Appliaction.pdf".
[Code]...
im trying to join two tables together, (this messaging system) and im having trouble with the query.
Select Message_ID, Firstname, Surname , Subject , Message FROM messages, guardian_users INNER JOIN messages ON guardian_users.User_ID = messages.Sender_ID WHERE messages.receiver_ID = 3
and im getting this error: #1066 - Not unique table/alias: 'Messages' (joining tables Messages and guardian_users)
I know you can alias an Imports statement in
Imports xyz = ProjectABC.ClassABC
But if I want to use the Project Properties, Reference tab to select a namespace to allow a project-wide setting, is it possible to alias that namespace?
Here is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
Code to add a new row to my datagrid on click of add button. I am not binding my grid to a datasource.I m fetching values from the database through a datatable n then through a lood inserting t values to my datagrid. i m not binding the entire datatable as my datasource for the grid.
View 2 RepliesI have 2 datagrids. One to show Product information and another for Product purchase details entry.Both share the same dataset. The dataset (ds) is filled up with columns from 2 table
ProductMstrTbl : ProductID, ProductName..
ProductDetailsTbl: ProductID, PurchaseDate, Amt, BalanceQty..
[code].....
I'm having a hard time on using Transaction then after that I need to use sqldataadapter. When I tried the code below I'm having an error "ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized." Pointing to this block.[code...]
View 1 Repliesim added a dataset inside my project, and inside the dataset i added a DataAdapter with the steps like below:Use SQLStatement --> select A,B from tb_example --> Fill a datatable.And then i bind one of my combobox datasource's display member = Avalue member = BAnd its work properly!After few weeks, im reopen the project and i try to add another new dataadapter in the previous dataset and a new combobox like steps i did before. When i come to the combobox and try to find the datasource in combobox's properties and i cant find the dataadapter i jz added.
View 7 RepliesI am trying to add a parameter to a sqlDataAdapter. I have tried to use parameters.add() but the adapter is not a sqlCommand. Here is some of my code.
Private Sub convertToCSV(ByVal SqlQuery As String)
Dim Dt As New DataTable()
Dim SqlCon As New SqlConnection("Data Source=db;Initial Catalog=productionservicereminder;User Id=id;Password=pass;")
[Code]....
Basically I am trying to do something like this:
Ada.Parameters.Add(New SqlParameter("@pgid", pgid))
This should be a fairly simple one. I am creating a dataset which will contain a description field which I would like to sort by. The reason I want to sort the dataadapter and not in my SQL is that I am already ordering by the results that have a particular value.My SQL looks like this:
SELECT pif_desc, pif_fund, psf_end, (CASE WHEN SUM(pmi_units) IS Null THEN 0 ELSE SUM(pmi_units) END) As fundunits
FROM tbl_mem INNER JOIN tbl_sfunds[code]....
I want to sort the datarows is ds.tables(0) by pif_desc but still have the rows with fundunits > 0 listed first. how I can achieve the correct ordering.
I have been researching all that is related to DataSources, DataReaders, DataAdapters, etc, with an Access 2010 DB bound to a DataGridView.
Everything is fine, just one line fails and is driving me nuts Here is the code:
[Code]...
The line that fails, actually updates my database, but somehow, the update is not performed on the line that belongs to the first row of the grid. What is more, if I change the value manually, the same update method works fine. What is going on here?
I'm trying to create a form that uses controls that are bound at runtime. All the data objects are declared at the form level. The Select statement includes the two fields that make up the PK form the table. The Owing_Company data displays in the bound control. I can change the text and in Save_Click the RowState is Modified and Row!Owning_company has the changed data. DsForm.HasChanges is False. A simple call in Save_Click daForm.Update(dsForm) does not change the DB. If I update the Row!Owning_Company in code dsForm.HasChanges is now true and daForm.Update changes the data. What am I missing that allows changes made via the bound control to modify the DataSet?
[Code]....
Can you explain to me what they a
View 1 Replies
