C# :: Searching DB For Value In Textbox (WPF)
Nov 3, 2014
WPF window I'm working on. I have a window that has a textbox to enter a name to search a database table for, and when the search button is clicked, the ID for that username will be returned to a separate textbox. The code I've written atm doesn't seem to be working, but it looks fine to me. Here's what I've got;
private void btn_SearchUsers_Click(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrWhiteSpace(txtb_SearchName.Text))
{
SqlConnection sqlCon = new SqlConnection(conStr);
[Code] .....
So, I have the value entered into the textbox to be searched for stored in a variable, I'm selecting the ID from the table when the name in the variable is found, storing the result in a DataTable, and then in my foreach loop, if I find the name (the name column being index 1 in the table), I set set the ID result textbox to equal the ID for that name (the ID column being index 0 in the table). I think the foreach part is what's throwing me off. Maybe the column stuff? My Users table is like;
ID Name
1 John
2 Roger
3 Mike
View 3 Replies
ADVERTISEMENT
Nov 22, 2014
This is a simple dictionary program, richtextbox is used for a results
but i wants to use textbox as a richtext box
(ex:money = dollar,penny,rupees)
as a list : dollarpennyrupees
/> /> /> />
Project 2 Dic.txt = Project 2 Dic.rar
Attached File(s) : Project 2 Dic.txt (61.32K)
View 1 Replies
View Related
Jul 30, 2014
In my code below the first textbox.appendtext works but the second, textbox1.appendtext(i);, gives an error;
The name 'textbox1' does not exist in the current context (CS0103).
Is it possible to put text into the textbox from this routine?
namespace textboxtest {
public partial class MainForm : Form {
public MainForm() {
InitializeComponent();
[Code] ....
View 3 Replies
View Related
Mar 28, 2015
I was following a c# book to write a WPF with a textbox. When the textbox is selected(got focus) with keyboard or mouse, it will select all text in it. I followed the book and wrote this:
private void TextBox1_GotFocus(object sender, RoutedEventArgs e) {
TextBox1.SelectAll();
} private void TextBox1_PreviewMouseLeftButtonDown(object sender, MouseButtonEventArgs e) {
var control = sender as TextBox;
[Code] ....
The book said having "e.Handled = true" is to stop the event in order to prevent the cursor being positioned on somewhere of the text instead of selecting all text. From my understanding, "e.Handled = true" is for stopping routed events. Is this means that something will run if "e.Handled = true" is not there? If yes, then what is it?
View 2 Replies
View Related
Oct 23, 2013
I have an assignment to create an address book in c++ where you can enter contact information and then search all entries via last name. I am trouble figuring out how to write a function that will be able to search an entry by last name. Here is my code so far:
#include <iostream>
using namespace::std;
class addBook {
[Code]....
View 1 Replies
View Related
Sep 13, 2014
I am not able to get my textbox values in my Register class for my calcTotal method. However, if I convert the text to a double in the Form class and then pass that to my function it will work. But I don't understand why I need to do it like that.
namespace CashRegister {
class Register : Form1 {
public double getItemPrice(string str) {
double item = 0;
item = Convert.ToDouble(str);
return item;
[Code] .....
View 2 Replies
View Related
Dec 20, 2014
How to use Masked Text Box if I want to use a string for mask? There is a question in the program and I want to be able to type in only the correct answer. So if the correct answer is Blue, and I start typeing It only accepts for the first caracter is B, then l and so on...
View 11 Replies
View Related
Aug 5, 2014
I have a textbox with XAML
<TextBox Grid.Row="0" Grid.Column="1"
HorizontalAlignment="Stretch" VerticalAlignment="Center"
Text="{Binding Path = EventDate, Mode=TwoWay}" />
And the Property
[edit]Note that auto formatting has edited onpropertychanged to all lowercase[/edit]
/// <summary>
/// Date that the event took place
/// </summary>
public string EventDate {
[code]....
In the constructor I have
EventDate = "Enter Date";
I have added a button
<Button Grid.Column="3" Content="Add Record" VerticalAlignment="Center" Click="AddRecordButtonclick"/>
public void AddRecordButtonclick(object sender, RoutedEventArgs e) {
Debug.WriteLine("Date value: " + EventDate);
}
What I am finding when I run this code is that when the Add Record button is clicked, the output displays, "Date value: Enter Date" regardless of what text I have in the textbox bound to EventDate.
Is there something obvious which I am missing with binding of a string to a textbox?
I've added this to the xaml, but the property is still not updating in the debug line
<TextBox Grid.Row="0" Grid.Column="1"
HorizontalAlignment="Stretch" VerticalAlignment="Center"
Text="{Binding Path=EventDate, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" />
View 7 Replies
View Related
Oct 28, 2014
All I want is to let the user enter a value such as .55 or say, .34 and use that in a calculation.
I cannot get passed the errors.
double theRate;
double totalMileage;
double amountOwed;
private void btnCalculate_Click(object sender, EventArgs e)
[Code] ....
So how do you get numeric input from a user?
View 3 Replies
View Related
Apr 24, 2015
I have a silverlight app that uses TextBox XAML controls.
In the c++ code-behind, IXRTextBoxPtr types are associated with these textboxes using "FindName" like this:
FindName(L"ColNum3", &m_pColNum3);
(where ColNum3 corresponds with the XAML CODE like this: )
Then, the code assigns the pointer like this:
std::wstring wsTransfer; // gets the wstring from imput
const WCHAR * wpszInput;
wpszInput = wsTransfer.c_str();
m_pColNum3->SetText(wpszInput);
but the display does not show the text data.
What am I missing? What steps am I missing to have this text modification display on the screen?
View 6 Replies
View Related
Feb 13, 2013
how to add textbox in datatable in c#
View 3 Replies
View Related
Jan 26, 2015
I have a text format like this:
12-22-24-22-33-13
When user click a button then check for duplicated number in that text. How to handle this in C#.
View 1 Replies
View Related
Feb 6, 2013
My .csv file is like:
Bone,origin,deep/superficial,location, action.
with list of 38 bones.
This is my main.cpp:
#include <iostream>
#include <fstream>
#include <sstream>
#include <vector>
#include <cstdlib>
#include "Action.h"
#include "Action.cpp"
[Code] .....
For action, if user enters action, it will output the bones involved with that action.
For strengthening, if user enters location, it will output bones involved with that location.
For dagnostic, if user enters bone, it will output location of bone and whether bone is deep/superficial.
How I could search in csv file for these.
View 11 Replies
View Related
Oct 31, 2013
I am writing a program in Visual C++ 10 with 2 forms.
In the first form I have a textbox and a button. The button opens the second form.
In the second form, I have a button that changes the text in the textbox in form1 to an item from a listbox in form2.
Here is my problem. When I do the code for the button in form2 to change the textbox in form1 I get the errors:
error C2065: 'textBox1' : undeclared identifier
error C2227: left of '->Text' must point to class/struct/union/generic type
I thought maybe I should just include the "Form1.h" file but I can't do that because I already included "Form2.h" in form1 in order to be able to open the second form. If I try to include form1 in form2, it says that the code to open form2 is an error now.
My question is, how can I access identifiers such as "textbox1" from other forms and other files when I already used the first form to open the second form? I also want to know how to do this for all identifiers between all files.
how to print the selecteditem from a listbox into a textbox because that doesn't work by just setting them equal either.
Here is my code:
#pragma once
#include "Form2.h"
namespace Test1 {
using namespace System;
[Code].....
View 11 Replies
View Related
Apr 13, 2014
How can i jump from textBox to next texBox when i press enterKey in c# , what i the event for that .....
View 2 Replies
View Related
Jul 12, 2014
This program with DLL that check number enter in textbox and use RGB for change color
example: if user enter 000 (000:black) changed color automatic textbox to black, and other 111 ....
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
[Code]....
View 4 Replies
View Related
Mar 16, 2014
I want to display a gridview when a textbox is focused. The gridview is hidden when the page is loaded and as soon as the focus is on the textbox the gridview should be visible.
Here is my code
<asp:TextBox CssClass="txt" ID="txtEducation1" AutoPostBack="true" runat="server" onfocus="MyFunction"></asp:TextBox>
protected void MyFunction(object sender, EventArgs e)
{
gridview1.Visible = true;
}
View 1 Replies
View Related
Jul 28, 2014
I need to display values from my array that I get from my textbox 1 into my textbox 2 with the following format:
char[0] "whatever" char[2]
void Button1Click(object sender, EventArgs e) {
string text = BIRTH_DAYW2.Text;
string [] split = text.Split(new char[] {'/'});
for(int i = 0; i < split.Length; i++)
[Code] ....
View 2 Replies
View Related
Sep 29, 2014
I'm having a little problem with System::String and terminating the text to end the line in the textbox, I tried adding
to the string in multiple ways (Insert, or just + " ")) but the text is still appended in one single line.
However converting a properly terminated char array to a string and appending it to the textbox works. So, let me explain my code a little more: I have a function which appends text to the textbox (I use it from a different thread thus I needed to use Invoke):
void mainTextboxAppendText(String^ text) {
if (this->mainTextbox->InvokeRequired) {
dMainTextboxAppendText^ d = gcnew dMainTextboxAppendText(this, &mainForm::mainTextboxAppendText);
this->Invoke(d, gcnew array < Object^ > {text});
} else {
this->mainTextbox->AppendText(txt + "
");
}
}
But when I try to call it multiple times with different strings then they do not appear in new lines but they're all in one single line, I've tried doing it like:
txt->Insert(txt->Length, "
");
this->mainTextbox->AppendText(tx);
I've also tried using Environment::NewLine, but it still didn't work, so what I finally came up with was converting the system string to an char array using Marshal and inserting an " " there and then converting it back to an system string, then it was ok .
View 3 Replies
View Related
Mar 2, 2014
So I have assigned this method to each TextBox. It works fine pressing the left arrow and right arrow, but for some reason will not work using the up and down arrows. I have tested the string, using MessageBox and it is correct...the loop even proves it finds a matching TextBox. It is correct as in it displays the TextBox name it should be selecting but doesn't. I have no clue! Now the first select method is the one I want to use, I used the loop to check to see if it was even finding a match. It does find it but doesn't select it. The naming convention for my text boxes is r1c1 where the first number indicates the row and the second number is the column. There are 9 rows and 9 columns. This SHOULD be working but for whatever reason it is not. I've even put a message box inside the if statement for the up and down keypress check and it pops up when i press up or down.
private void Navigate(object sender, KeyEventArgs e) {
TextBox input = (TextBox)sender;
string nextBox = input.Name.ToString();
if (e.KeyCode == Keys.Left) {
if (int.Parse(nextBox.Substring(1, 1)) > 1 && int.Parse(nextBox.Substring(3, 1)) == 1)
[Code] ....
View 7 Replies
View Related
Oct 28, 2014
I am trying to create an application interface serial data reception using c #. I send the data from the serial adc microcontroller adc atmega 16 ... the data is 0 to 1023. In the textbox that I use as a data reception, data updates to the bottom if I use ReadLine coding.
examples:
1023
1023
1023
256
669
If I use ReadExisting, the data displayed by the textbox moves to the side. examples 102310231023256669
When the data changes from 0-1023 of serial communication, and clear the data will store in otomatiis in the textbox.
When there is reception of data with a value of 1023 and immediately there is a change to the value of 555 textbox value will not store the value of 1023, I want the value in 1023 immediately deleted automatically and change the value to 555 when a change in the value of the data ...
The following is the complete source code:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace serial {
public partial class Form1 : Form {
[Code] .....
View 6 Replies
View Related
Oct 3, 2014
I am trying to get 2 numbers from 2 textboxs and get a return sum in the third textbox. the strange thing is that i got it to work with this code that i am going to provide on the last app i worked on, now on the new app i am on it doesnt work at all.. I am not getting any Errors, just shows a zero when i calculate to the sum of the total textbox.
int sum1 = 0;
int sum2 = 0;
int result = 0;
if (int.TryParse(txtPrice.Text, out sum1) & int.TryParse(txtQuantity.Text, out sum2))
result = sum1 * sum2;
txtSubTotal.Text = result.ToString();
View 11 Replies
View Related
Oct 20, 2014
How to find getthe textbox value in a datagridview & how to delete it?
View 1 Replies
View Related
Apr 27, 2012
I have an ms access database with 2 tables in it which I named Customers and Products. I am using visual studio 2010, in my windows form I have 4 textboxes and 3 button in it, for my 1st textbox when I entered one of my ProductCode such as 10111, then press the Display button, the other remaining 3 textboxes should populate and display the following;
ProductID: CH001
ProductName: Chocolate Strawberry
ProductCode: 10111
Then the 2 remaining button named NEXT and PREVIOUS, should be able to display all my product name with 10111 product code.
View 7 Replies
View Related
Jul 18, 2014
I have managed to make text dynamically appear in a text-box while I enter text into another.
how ever I would like to know to to limit the amount of text that is dynamically entered(I'd say about 10 characters at most).
here's a sample of what I have done so far:
Random r = new Random();
int IDrandom = r.Next(0, 9);
Emp_ID.Text += IDrandom.ToString();
//Emp_ID.MaxLength = 10; does not work
View 3 Replies
View Related
Dec 26, 2014
i create two forms add a password in first form throgh user input and second form will open i want that password will automatically be added to second form. first form is ok working according to my expactations but problem that it does not enter pssword in second form i reference that textbox that is
stdfrm std=new std();
std.a=txtpwd;
it displays an error that cannot implicitly convert type system.windows.forms.textbox to string
View 1 Replies
View Related
