|
Yes i saw the links. now i'm reading their content
and i am trying to figure it out. Thank you
|
|
|
|
|
Thank you for your help. I am new to SQL
I am trying to assemble the code. It's a bit hard for me, since it's my first time with SQL.
If you can assemble the code for me I will be more than thankfull
Thanks again.
|
|
|
|
|
Nobody is going to do your work for you. We all have our own code to write.
The conversion from Access to SQL is rather simple. Wherever you have "OleDb..." you replace with "Sql". That includes OleDbConnection, ...Command, DataReader, ...
|
|
|
|
|
Guys I have made a editor with richtextbox.After entering text and while saving,it is saved as ".txt" but how to save it in "rtf" format.
Plz Help me it is saved only as ".txt" and not as ".rtf".
|
|
|
|
|
Without seeing the code you're using to "save", it's impossible to tell you what you did wrong.
|
|
|
|
|
Which property of the RTB did you read? There's two that might be used; one that returns plain text, one[^] that returns the text with RTF encoding.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
plz.. help me. how to host win form appl in web. i read some blogs,first convert win form application to wpf. then host that wpf in iis.
if it's the process how to convert .
|
|
|
|
|
Kindly don't repost your question across multiple forums.
|
|
|
|
|
can we work .net4.0, visual studio 2010,mysql 5.6 with tomcat7.0
.is it possible to work tomcat server with .net
|
|
|
|
|
It is possible using a project called Mono - not directly.
|
|
|
|
|
|
Hello Every Respected Engineers.
I am working of a Billing Software. My Question is that:
I have a Challan and ChallanDetails Table. To show ChallanDetails ( list of product and rate etc) for a Challan, I have used a bound datagridview in which these columns are there
SrNo
ProductID
Qty
Rate
Amount
now when I show any existing challan, I have used datagridview's CellFormatting Event to show name of the Product instead of its ID. This works perfectly fine
My problem is that while making new challan entry, I have to type the ProductID (which is hard to remember). I want that when user types the name of the product, it should store its ProductID and show ProductName in that column. But when I type the name of product and press enter, I get the system error message of invalid format because it is a Numeric column and wont allow text.
Please give me suggestion how can I do this.
Thanks in advance
Dinesh Prajapati
Dinesh
|
|
|
|
|
I am sorry to have to state the obvious, but you need to change the column type so it will accept the product name.
Veni, vidi, abiit domum
|
|
|
|
|
Thanks for your quick response
But Sir, the dgv is bound to a bindingsource and the column is integer type. I tried a lot but couldnt find any option to change the type of datagridvew column to text. and i dont want to change the database column itself.
Thanks
Dinesh
|
|
|
|
|
|
I think your columns are perhaps Numeric Type.
But you want to input your ProductName typed in String. So there must be a error message occured.
To Solve this, You have to change your columns type which store product information. Thank you.
|
|
|
|
|
You question is a typical example of "id" as value versus "name" as display, id is unique and is the primary key of a database table but name is the description and not unique. It is unreasonable to remember ids, and it is error prone to type names. Solution is to have a combo box populated with ids as value and the corresponding names as text. User will only see list of names in the combo box for their selection, when selected, your program will then capture the value that is the id of the selected name.
In C#, you can create a combox box whose ValueMember = "id" and DisplayMember ="name" and add this combo box to a datagridview column.
In this way, users neither have to remember ids nor names, and no typo either.
|
|
|
|
|
Dear Sir Peter,
Thank you for quick and response with a detailed information.
I just saw your post today. Sir, I know that we can use a combobox's ValueMember and DisplayMember property to do the task..
But in combobox, user cannot type the name of the product. The user has to select if from the long list which consumes time.
What I wanted to do is that a user types few letters, the suggestion should appear and then he can select it and press enter and its ID stored in the Column.
But now I have done it myself, I had to define a use control and used it in the Grid.
Thankyou everbody once again.
Dinesh
|
|
|
|
|
Well done. Best new year wishes to you.
|
|
|
|
|
Thank You Sir.. Wish u Happy New Year
Dinesh
|
|
|
|
|
Hello
i need your help in something.
I have a DataBase. I need to search it, If found, i want to display the record into my textboxes and comboboxes.
This is my code. it works with no errors. But i don't know how to display the data from SQL into my form.
Private Sub btnSearch_Click(sender As Object, e As EventArgs) Handles btnSearch.Click
If CheckBox1.Checked = True Then
Dim strconnection As String = "Data Source=ELIANE-VAIO\SQLEXPRESS;Initial Catalog=SchoolDB;Integrated Security=True;"
Dim _cn As SqlConnection = New SqlConnection(strconnection)
Dim cmd As New SqlCommand
Dim cmd1 As New SqlCommand
_cn.Open()
cmd.Connection = _cn
Dim r As DataGridViewRow
For Each r In Form1.DataGridView1.Rows
cmd.CommandText = "select * from StudentInfo where Code = <a href="/Members/t1">@t1</a>; "
cmd.ExecuteNonQuery()
Next
If MessageBox.Show("Record Found. Do you want to display the record in the textboxes?", "Found", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = DialogResult.No Then
MsgBox("Display Cancelled")
Exit Sub
Else
MsgBox(":)")
End If
End If
End Sub
Thank you in advance
|
|
|
|
|
A select statement is actually a query, so you wouldn't use ExecuteNonQuery. What I would tend to use, in this case, would be a SqlDataReader. You can find a sample of how to use it here[^].
|
|
|
|
|
Hello everyone!
So nice to b back. Last time was about 10 years ago!!!
So, to the point...
We are working on webapp that has different branches and so on...
the issue is that once a developer is on branch A and modifies the webconfig for the debug mode most of the time he/she checks in that webconfig by mistake and the same (now wrong) webconfig ends up on our release branch...
the main idea is to apply the transformation on a debug mode... but it is not happening...
Any idea?
Kind regards.
Leo.
|
|
|
|
|
Sorry, I don't you what you want.
|
|
|
|
|
About the issue we are having, its basically that we cant run the debug with the right
webconfig transformations. Lets say we have envrionment A, and this same environment uses its own
webconnections and so on; the same thing with environment B. When we run the debug (f5) lets say for environment A, the page is not loading the webtransform for env A.
How can we run debug with the right webconfig without the need to change the "main" webconfig but rather changing the webtransforms?
Kind regards,
Leo.
|
|
|
|