kvprajapati

Use (MS-SQL) CASE construct. [code] ... CASE WHEN STATUS=1 THEN AttendenceTime else ' ' END as TimeIn, CASE WHEN STATUS=0 THEN AttendenceTime else ' ' END as TimeOut ... [/code]

[b]>suggest which database i should.[/b] Any database product you can afford. [b]>Can google search the data in any one of databases if i will provide the the links, For better SEO, suggest me also.[/b] Hire the SEO service.

Learn the database integration class lib - ADO.NET.

Did you changed Compiler option - Target CPU - x64?

Try to use generics. [code] Dim myItem As New List(Of String) myItem.Add("a") myItem.Add("b") myItem.Add("A") Dim k = From item In myItem Order By item Descending Select item ListBox1.DataSource = k.ToList() [/code]

This DLL must have Read and Read & Execute permissions.

[b]>So that Any Genius Can Answer these Question Correctly[/b] I suggest you to read some books/msdn online pages.

[b]>inserting data through textbox [/b] Use parametrized query. [code] .... Dim ssql As String = "insert into nikhil values (@p1,@p2,@p3)" cmd = New System.Data.OleDb.OleDbCommand(ssql, conn) cmd.Parameters.AddWithValue("@p1",textbox1.text) cmd.Parameters.AddWithValue("@p2",textbox2.text) cmd.Parameters.AddWithValue("@p3",textbox3.text) conn.Open() cmd.ExecuteNonQuery() conn.Close() .... [/code] [b]>I am not able to connect to the server in sql server 2005 it is asking for …

[b]>Error 1 Use of unassigned local variable 'last_Crawl_Date'[/b] You must initialize the local variables. [code] DateTime last_Crawl_Date=DateTime.Now; [/code]

Have a look at these articles: 1. [url]http://vbnet.mvps.org/index.html?code/enums/enumprinterdrivers.htm[/url] 2. [url]http://vbnet.mvps.org/index.html?code/system/addprinter.htm[/url]

[b]>like if f1 - f12 is pressed then nothing happen like nothing have been touch.[/b] Disabled the function keys. Have a look at MSDN articles: 1. [url]http://msdn.microsoft.com/en-us/library/ms537184%28VS.85%29.aspx[/url] 2. [url]http://msdn.microsoft.com/en-us/library/aa770041%28VS.85%29.aspx[/url]

[b]>So that after booting up the OS and login the verse of the day will be displayed on the screen.[/b] Add a link of your program into [b]startup[/b] menu item.

[b]>how do i do that ?[/b] Write a window service and scheduler to call the page every [B]n[/B] minutes.

[b]>that i have a problem with filtering the data with the date.[/b] Show us your code please.

Use [B]sqlCmd.ExecuteReader()[/B] instead of [B]sqlCmd.ExecuteReader[/B]

You need to use Win32 API. Take a look at this [URL="http://social.msdn.microsoft.com/Forums/en-US/vbinterop/thread/64272f0f-e9e3-485d-b191-5f7651196870"]FAQ.[/URL]

[b]>This tool is to prevent users to know the site so they can't steal or copy the files.[/b] If your application is web then use URL rewrite feature.

Hi tabseer. Can you maybe provide some more information about what it is you are trying to do?

[b]>language is asp.net[/b] ASP.NET is not a language (Its an extended class lib of .net framework). >? Please purchase some good books, read them and implement.

Have a look at this [URL="http://karlshifflett.wordpress.com/2008/10/11/viewing-design-time-data-in-visual-studio-2008-cider-designer-in-wpf-and-silverlight-projects/"]article.[/URL]

[b]>Transfer value from one page to other [/b] Method - 1 Cross Page posting (PostBackUrl Property) Method - 2 Query String (Request collection) Method - 3 Session. FirstPage.aspx [code] .. Session("text1")=TextBox1.Text Response.Redirect("NextPage.aspx") [/code] NextPage.aspx [code] .. var1=Session("text1").ToString() ... [/code]

[b]>what wrong with the code ?[/b] Maybe you need to verify the code of ReadData_Logic. Run your program at cmd, [code] c:\folder>programName c:\xyz\file.txt [/code]

[b]>My asp textbox is not getting focus when i clicked on the textfiels.[/b] Remove style and css class and see what happens.

Make sure that the copy of that dll is in another folder (other than project). Now, add the reference of that dll using menu project + Add reference menu item into your project.

Have a look at - [url]http://social.msdn.microsoft.com/forums/en-US/csharpgeneral/thread/86e3437e-900c-49d9-a526-fc24ab7ffa22[/url]

Please read the rules before posting - [url]http://www.daniweb.com/forums/thread78223.html[/url] [code] vbstr = "UPDATE [EmpMaster] SET [Name]= '" & UCase(txtname.Text) & "',[Address]='" & Trim(UCase(txtadd.Text)) & "',[TeleNo]='" & txttel.Text & "',[MobileNo]='" & txtmob.Text & "',[E-mail]='" & Trim(txtemail.Text) & "',[ARight]='" & Trim(cmbrht.SelectedItem.ToString()) & "',[Post]='" & txtpst.Text & "',[JoiningDate]='" & Trim(txtdate.Text) & "',[Salary]=" & Trim(txtsal.Text) …

Steps: 1. Right click on field. 2. Choose Format Object 3. Add expression to suppress field e.g [code=text] if length({table.StrcolumnName})=0 then true else false [/code]

Qualify the fields. [code] this.listBoxCust.DisplayMember = "Cust.CompanyName"; this.listBoxCust.ValueMember = "Cust.CustomerID"; this.listBoxCust.DataSource = DS; [/code]

[b]>I am having trouble connecting to a sql database.[/b] Firstly, learn the [URL="http://msdn.microsoft.com/en-us/library/h43ks021%28VS.71%29.aspx"]ADO.NET class library[/URL]. [b]>Is it possible to use vb.net 03 to access SQL 2008?[/b] SqlClient provider (database integration lib) exposes the functionality of MS-SQL server version 7.0 or later. [b]>Can I hard code the connection into a vb.net …

Do not load data into dropdown when a page is posted back. [code] if(!IsPostBack) { //load data into dropdownlist } [/code]

[b]>Is it the right way to pass arrays?[/b] Add [B]unsafe[/B] in the function declaration: [code] .. public static unsafe extern IntPtr INPUT(int a, int b, double *D, double *Z, double e, double f); [/code] and also add /unsafe switch to compile your program.

[b]>how can i define a connection string that automatically takes the name of system on which the software is loaded.[/b] 1. Add connection string entry into app.config [code] <configuration> <configSections> </configSections> <connectionStrings> <add name="CnStr" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> ..... [/code] 2. Add the reference of System.Configuration assembly. …

Do not use PostBackUrl property. Use Server.Transfer or Response.Redirect method to transfer a user on another page.

[b]>I need help updating a record from my database.[/b] Use ExecuteNonQuery() method for non-query statements (other than select statement). [code] cmd = New OleDbCommand("UPDATE [Users] SET [Type]=@type WHERE [Username]=@username", con) 'Add new user with following parameters Dim a As Object a = ListBox.SelectedItem cmd.Parameters.AddWithValue("@type", "Admin") cmd.Parameters.AddWithValue("@username", a) 'Open database connection …

[b]>Show diiferences in files[/b] [URL="http://diffplex.codeplex.com/"]DiffPlex[/URL].

[b]>i want to access database table nextrecord directly using either query or Logic.[/b] Use session. [code] Sub Page_load() If Not IsPostBack Then .... Dim adp as new SqlDataAdapter("select * from tab1","connection_string_here") Dim dt as new DataTable adp.Fill(dt) Session("dt")=dt End If End Sub [/code]

Take a look at [URL="http://www.c-sharpcorner.com/uploadfile/scottlysle/wordprocessor02042007234628pm/wordprocessor.aspx"]this[/URL] article.

Change the sequence of two statements: [CODE=C#] F.Show(); F.Location = P; [/CODE]

[b]>Undefined Exception Behaviour?[/b] Undefined behavior either not allowed or throw an exception.

[b]>Performace of my code when reading row by row data[/b] Do you know about data caching? Have a look at this article - [url]http://www.codeproject.com/KB/web-cache/cachingaspnet.aspx[/url]

[b]>Please what do I do?[/b] You can't deploy your web app in sub-folder. Create/configure sub-domain.

sniigg, Please read the rules before posting again, in particular the 'keep it organized' one - subject titles such as 'help urgent' are not allowed. If you hit 10 infraction points your account gets an automatic ban, so it is worth obeying the rules if you want to continue to …

[b]>NHibernate to connect to an SQL Server database?[/b] Have a look at [URL="http://code.google.com/p/fluent-nhibernate/"]fluent-nhibernate[/URL] and [URL="http://wiki.fluentnhibernate.org/Database_configuration"]wiki[/URL].

[b]>Zipping a Folder with Directory structure[/b] Learn/use classes from [URL="http://msdn.microsoft.com/en-us/library/system.io.packaging.package.aspx"]System.IO.Packaging[/URL] namespace. Have a look at codeproject article - [url]http://www.codeproject.com/KB/files/ZipUnZipTool.aspx[/url]

[b]>How do i join two tables in MySQL to form a third table having..[/b] You have to learn JOIN syntax.

[b]>.how can I avoid this redundancy?[/b] Suppress the repeated item/value.

Have a look at this sample that uses a custom datasource, MyListItem.cs [code] public class MyListItem { string _text; string _value; public MyListItem() { _text = string.Empty; _value = string.Empty; } public MyListItem(string text, string value) { _text = text; _value = value; } public string Text { get { …

[b]>Wanted help in connecting to a MySQL database named ..[/b] Please check the MySql Connector documentation.

[b]>Can anyone help me out? [/b] Do not use array to store name and id. Use DataTable object. [code] Dim dt as new DataTable dt.Coumns.Add("Id") dt.Columns.Add("Name") .... dt.Rows.Add(1,"A") [/code]

[b]>however neither does anything appear.[/b] Place your code inside the [B]Paint [/B]event handler of a form. [code] private void Form1_Paint(object sender, PaintEventArgs e) { Bitmap bmp = new Bitmap(@"c:\folder\file1.gif"); Graphics g = Graphics.FromHwnd(this.Handle); g.DrawImage(bmp, 10, 10); } [/code]