Here's the case I created this Permias.mdf on another solution that I had and then after that I decided not to use that solution and created a new website from visual studio and copy and paste the .mdf file to be used for this website.
Database 'C:\Permias.mdf' already exists. Choose a different database name.
I have a aspxtextbox and its validated from database.If text exists in database then it shows message Username exist.Now this is all happens on click of a aspxbutton after typing some text into aspxtextbox.I just want that when user defocus the textbox then it will automatically check from database and shows the message if exists.
View 1 RepliesI have "Order" object with Columns Ticket,OTP and CustomerName etc.Intially on DataGrid, I'm binding Ticket only , when user clicks on "Column Chooser" button, another windows appears to pickup CustomerName,OTP columns to add specified column dynamically on Datagrid. Environment : Asp.net ,C# with Object Data source
Public Class Order
{
publc void Order()
{
}
public string Ticket
{
get
{
return this.strTicket;
}
set
{
this.strTicket = value;
}
}
public string OtpNumber
{
get
{
return this.strOtpNumber;
}
set
{
this.strOtpNumber = value;
}
}
public string CustomerName
{
get
{
return this.strCustomer;
}
set
{
this.strCustomer = value;
}
}
}
}
I would like to check whether a folder exists or not if not create. I'm sure this folder exists, but for some reason I get "false" when I check with "Exists" method.
The only reason I think could be because of the W: drive? I moved this application to production site and even there it returns false.
while I'm type in Windows explorer on my localhost and on the server "W:/Webs/ASPPages/cropper/uploads" it opens this folder. So my localhost and IIS server has W: mapping.
for test I tried to create the folder then it says can't find the path...
userFolderName = @"W:/Webs/ASPPages/cropper/uploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried "W:\Webs\ASPPages\cropper\uploads"
DirectoryInfo dirInfo = new DirectoryInfo(userFolderName);........
I have a SQL database that creates a record for every document uploaded by the user to the server. I want to check this table before a user uploads a document to ensure they don't upload a file with name that already exists.
I know how to make the connection and make the SqlCommand to query the table for an existing record. But I don't know how to check the record count from the sqlCommand I made.
Does that make sense?
Using myConnectionCheck As New SqlConnection(myConnectionStringCheck)
Dim myCommandCheck As New SqlCommand()
myCommandCheck.Connection = myConnectionCheck
myCommandCheck.CommandText = "SELECT * FROM Req_Docs WHERE Doc_Name =" & DocName
myConnectionCheck.Open()
myCommandCheck.ExecuteNonQuery()
End Using
I want to develop the feature to check whether username is available in database using ASP.Net and SQL server ....
View 1 Replieswhat is code of "user already exists in database" using asp.net 3.5
View 1 RepliesI need to somehow test if a table exists in a database. If it does not then I need to create the table. How can I test for existence of a table using SQL? It seems like some type of SQL logic is needed?
View 2 RepliesI am learning a tutorial, it is about saving mp3 files in database.
Have a look below picture i can upload a mp3 file multiple time with the same name how to avoid it?
[URL] ...
protected void btnUpload_Click(object sender, EventArgs e)
{
using (BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream))
{
byte[] bytes = br.ReadBytes((int)FileUpload1.PostedFile.InputStream.Length);
string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
[Code] .....
I want to validate the email id in clients side, so that to prevent the postback of page to server, and every user should registered with email id... so i want to validate email id at client side.. i.e. should be check it is exist in the database or not.
View 1 RepliesI have a asp:Button and asp:Textbox on Default.aspx page
Code is as below:
<asp:Button ID="Button1" runat="server" Text="Save" Width="80px" CommandName="Update"
OnClientClick="EnableDdlCompany();saveButtonClick();" CommandArgument="Save" OnClick="btnSave_Click"/>
<asp:TextBox ID="txtBarcodeNumber" runat="server" MaxLength="11" Width="230px"
Text='<%# Bind("BarcodeNo") %>' Display="None"
OnTextChanged="TextChanged" AutoPostBack="true"></asp:TextBox>
On button click, I want to call a javascript code to check that If the entered BarCode Number in Textbox already exist in Database, then show an alert "Number already exist" else allow user to save and navigate to Default2.aspx
I can able to do the same checking on TextBox OnTextChanged event using c# code, as below:
protected void TextChanged(object sender, EventArgs e) {
TextBox txtbarcode = fvIPRForm.FindControl("txtbarcodenumber") as TextBox;
if (txtbarcode.Text.Length > 0 && txtbarcode.Text.Length < 11) {
string error = "The Barcode Number " + txtbarcode.Text + " is invalid, the barcode length must be 11 character.";
ScriptManager.RegisterStartupScript(this, typeof(string), "Successful", "alert('" + error + "');", true);
[Code] ....
Here, IPRRequest is the class/.dll file name and IsValidBarcodeTest is a function defined in the class file
But same checking I tried using the c# code on button's OnClick="btnSave_Click" event, but dont know why this event is not firing, I guess due to CommandArgument on button, but I am not sure.
That's why I want to achieve it using Javascript.
I need to check whether table named 'CSE' is existing in database or not. if it exists, i want to drop the table 'CSE'.
View 1 RepliesI want to check the entered email id already exists in my database or not. For that I need the Text box lost focus event so that I can call it in update panel trigger asynchronously. whereas in my event I can check whether the entered value exists in database or not.
I tried:
txtEmailId.Attributes.Add("onblur", "javascript:CheckEmailIdIsExist()");
If so, the what should be inside CheckEmailIdIsExist() javascript method? how to check database values asynchronously from javascript function?
I have one text box in my page and 1 button
users type some number in this TB
I want when users enter their number in text box and click on button to insert it to database
it checked if in database was that number it show message that "this number is in database please type other number"
how i can do it?
In this article u describe how to check
[URL]
But I want to Data retrive from data base in this way can u tell me using java script and query string
i want if i search UserName 'xdeeeee' that is not exist in database then a label should display saying "Sorry ‘USER NAME’ not found".
have a look below picture.
<asp:TextBox ID="SearchByUserName" runat="server"></asp:TextBox>
<asp:Button ID="SearchByTagButton" runat="server" Text="SEARCH" OnClick="SearchByTagButton_Click" /><br />
[Code].....
I have a form for data entry which has a checkbox for featured item.
Only one feature item should exists in the database.
How can I check when doing the insert if another item in the table is a feature item?
I would likt to deactivate the one as feature and activate the new one.
Possible Duplicates: Advice on using ASP.net WebForms or MVC, How to decide which is right, WebForms or MVC when doing ASP.NET
I am new to web development and asp.net... I was going through asp.net website and 'n' number of question here in stackoverflow regarding Webforms or MVC.... But still as a beginner can't get an idea what to choose?
What should i choose webforms or mvc?If MVC,What should i know before getting started with it?If webforms,What should i know before getting started with it?
I'm a seasoned programmer with years of experience in Windows Forms development using different programming languages as already stated in this question: Will learning WPF improve my skills in ASP.NET? ASP.NET or any Web based programming language doesn't feel natural for me to explore or to use. Although I am unfamiliar with Web based technologies, my curiosity about these grows and grows. In addition to it, I am aware of the market place Web based programming takes. I would like to expand my knowledge and experience to the Web, though would it be just to know what I'm talking about instead of speculating whatever.
My experience as an information and process systems developer allows me to understand the concepts and some of the basics. I am aware that Web based applications are stateless, for instance, and that I need to use session or viewstate variables to keep the information the user is working with alive, otherwise I would loose them. I also understand the basics of Ajax based controls such as the UpdatePanel, which is to update or to refresh only a part of a UI page rather than reloading everything through the connection again. I can get that CSS defines styles for your page's sections and that you may change radically your Website's aspect just by changing the CSS reference. I am also aware of masterpages, which I don't really understand, in fact.
Programming Model
I just watched this video about choosing the right model for me/my application:
Choosing the Right Programming Model. If looks like ASP.NET MVC, which I thought was the best approach, is more for the veteran Web developers, people who are comfortable with Web applications. I have used a lot of DataBinding in Windows Forms, and WebForms seems to be more what I'm looking for into ASP.NET, until they say that MVC allows for Unit Testing, TDD and Agile methodologies, which I adhere to, as a certified Professional Scrum Master. I'm a bit mixed up on what will be more natural for me speaking of programming model.
Questions
Taking into account my base of knowledge and my experience, what programming model do you think I'm going to be more comfortable with? Will choosing one over the other allow me to get acquainted enough with ASP.NET to one day try the other model? In the video about choosing the Programming Model both sat on ASP.NET, I heard about DataBinding while using Web Forms, but no mention of DataBinding in the MVC model. Is there any possible DataBinding in MVC?
I am using asp.net and c#.
I have a some classes. Some of the classes are having same methods insert, update and delete.
Each insert will insert different data to different table. (same for update and delete). What type of pattern can be applied for this kind of class.
i create a new web project there is two options to code 'C#' and 'VB.Net', I choose vb.net.....everything is working fine, now i want to add new webpage but in that page i want to write code in C# i know its possible because i did same job previously....but now the problem is when i go for add new item and choose web>webpage but there is single option to write source that is VB.net.....that is default setup when is choose new project.....
how to add C# page while choose new project in VB.net......
I have a RFID reader which reads my employee code. Now i want to log the date and time of the chip when it is scanned by the reader (ie) for an attendance system Login time and logoff time. I would like to use asp.net MVC and sql server 2005. how to integrate RFID with an asp.net mvc web application. Where should i start?
View 2 RepliesI have a dropdown list in my page which can load country list from a SQL database table. Now, I want to choose a country from that drop down list and If I click on the go button, then I want another query which can compare the country name(which I have selected) with another table and load the other necessary info from that table. If I specify the country name on the SQL command , then the data loads nicely(
<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" SelectCommand="SELECT [Zone_Name], [Card] FROM [Rates] WHERE ([Zone_Name] LIKE 'Canada%')">
[code]...
i have to choose the most popular venueselect max(count(Destination))as popular_venu from bookingthis shows me error.how do i solve this?nothr queriesselect max(count(Departure_time)from bookingwhere Departure_time>12:00:00i got error for both.please help me to sovle
View 5 RepliesLINQ to SQL
Entity Framework
MVC
We're rewriting a VB 6 windows application in C# for our intranet. Our organization has about 400 employees. Our database is SQL Server 2008. The application is a Human Resources Employee Administration System.
How does a group of newbies set out to choose the best approach to handling the data for this relatively small organization?
Any recommendations as which approach to try first or otherwise which one you consider the best approach and why?