Jump to content

naag

Members
  • Posts

    21
  • Joined

  • Last visited

About naag

  • Birthday 06/26/1990

Profile Information

  • Location
    Bangalore

naag's Achievements

Newbie

Newbie (1/7)

3

Reputation

  1. thankz for ur reply ....problem is to get the data from the stored procedure....sql connection is proper but im enable to get the data using stored procedure....???!!!
  2. hello... I have written a stored procedure to get a column Named as "Name" from the table DN_Software.The query is "Select Name From DN_Software Where DN_DiscoverHostID=5" for Particular ID. Now i want to display that list of names in front end page. please help me how to display using that stored procedure using asp.net displaying in c#.please... "ALTER PROCEDURE [dbo].[DN_Software_Read_Distinct_Name_By_DiscoveredHostID]( @Active [int], @DN_DiscoveredHostID Int) AS SELECT DISTINCT Name FROM DN_Software where DN_DiscoveredHostID = @DN_DiscoveredHostID --EXEC DN_Software_Read_Distinct_Name_By_DiscoveredHostID @Active = 1, @DN_DiscoveredHostID = 5" --------------this my stored procedure.
  3. naag

    Friends

    Hai... How to add friends in this forum and how to invite them and how to search in this forum..??
  4. Hello...Everyone... Myself Nagaraj... Good to see you all...
  5. Thanq for the solution but...in my case there is no "web form" folder in particular path ...even i searched in whole system....still unable to solve that...
  6. Hello everyone....!! In visual studio 2012 "web form" template has missed ...how to add or re-install the template....itz urgent ...and I tried to solve this by running the commond "denven/installvstemplates" in vs 2012 commond prompt but still iam unable to solve this ...please someone help me to solve this as soon as possible... plz plz plz.....!!!!
  7. Hello everyone....!! In visual studio 2012 "web form" template has missed ...how to add or re-install the template....itz urgent ...and I tried solving by running the commond "denven/installvstemplates" in vs 2012 commond prompt but still iam unable to solve this ...please someone help me to solve this as soon as possible... plz plz plz.....!!!!
  8. Hai..every one...im getting this error " Could Not Execute LINK.EXE" while compiling in vb 6.. thankz..in advance..
  9. hello...everyone. im getting this error whenever i start my system .on Desktop it will show this Error"call was canceled by the message filter.(Exception from HRESULT:0x80010002(RPC_E_CALL_CANCELED))"i donno what it is...please someone help me...im using Asus X54H ,Windows 7.. Thanku..!!
  10. Thank you boen_robot ...!!! even i have went throgh like this articles...i need some understandable words with easy way....that i got from you thanku once more.
  11. hello.. friends....please someone help me...just i need advantages and disadvantages of microsoft enterprise library over web and windows applications.Thank you in advance...!
  12. hello.. friends.... please someone help me...just i need advantages and disadvantages of microsoft enterprise library over web and windows applications. Thank you in advance...!
  13. Hai... iam new for C# ...im learning ..i created a table and showing it...now i want to update,edit and delete the records...i did it in my way...Problem is whenever i give save ,addnew or delete button it shows "Object reference not set to an instance of an object."this error at line 120 " cb.DataAdapter.Update(ds1.Tables["workers"]);"my program. using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms; namespace naag_database{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } System.Data.SqlServerCe.SqlCeConnection con; System.Data.SqlServerCe.SqlCeDataAdapter da; DataSet ds1; int MaxRows = 0; int inc = 0; private void Form1_Load(object sender, EventArgs e) { con = new System.Data.SqlServerCe.SqlCeConnection(); con.ConnectionString = "DataSource=C:\\Users\\g.nagaraj\\Documents\\Databases\\naag.sdf"; con.Open(); System.Data.SqlServerCe.SqlCeDataAdapter da; string sql = "SELECT*from tbl_naag"; da = new System.Data.SqlServerCe.SqlCeDataAdapter(sql, con); ds1 = new DataSet(); MessageBox.Show("Connection Open"); da.Fill(ds1, "workers"); //GridItemCollection.Datasource = ds1; //GridItemCollection.Databind(); NavigateRecords(); MaxRows = ds1.Tables["Workers"].Rows.Count; con.Close(); } private void NavigateRecords() { DataRow dRow = ds1.Tables["Workers"].Rows[inc]; textBox1.Text = ds1.Tables["Workers"].Rows[inc].ItemArray.GetValue(4).ToString(); textBox2.Text = ds1.Tables["Workers"].Rows[inc].ItemArray.GetValue(3).ToString(); textBox3.Text = ds1.Tables["Workers"].Rows[inc].ItemArray.GetValue(2).ToString(); textBox4.Text = ds1.Tables["Workers"].Rows[inc].ItemArray.GetValue(1).ToString(); } private void btnNext_Click(object sender, EventArgs e) { if(inc !=MaxRows-1) { inc++; NavigateRecords(); } else { MessageBox.Show("No more Rows"); } } private void btnPrevious_Click(object sender, EventArgs e) { if (inc > 0) { inc--; NavigateRecords(); } else { MessageBox.Show("First Record"); } } private void btnLast_Click(object sender, EventArgs e) { if (inc != MaxRows - 1) { inc = MaxRows - 1; NavigateRecords(); } else { MessageBox.Show("Last record"); } } private void btnFirst_Click(object sender, EventArgs e) { if (inc != 0) { inc = 0; NavigateRecords(); } } private void btnNew_Click(object sender, EventArgs e) { textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); btnNew.Enabled =false; btnSave.Enabled =true; } private void updateDB() { System.Data.SqlServerCe.SqlCeCommandBuilder cb; cb = new System.Data.SqlServerCe.SqlCeCommandBuilder(da); cb.DataAdapter.Update(ds1.Tables["workers"]); } private void btnSave_Click(object sender, EventArgs e) { DataRow dRow = ds1.Tables["Workers"].NewRow(); dRow[4] = textBox1.Text; dRow[3] = textBox2.Text; dRow[2] = textBox3.Text; dRow[1] = textBox4.Text; ds1.Tables["Workers"].Rows.Add(dRow); updateDB(); MaxRows = MaxRows + 1; inc = MaxRows - 1; btnNew.Enabled = true; btnSave.Enabled = false; } private void btnupdate_Click(object sender, EventArgs e) { DataRow dRow2 = ds1.Tables["workers"].Rows[inc]; dRow2[4] = textBox1.Text; dRow2[3] = textBox2.Text; dRow2[2] = textBox3.Text; dRow2[1] = textBox4.Text; updateDB(); MessageBox.Show("Data Updated"); } private void btndelete_Click(object sender, EventArgs e) { } private void label5_Click(object sender, EventArgs e) { } private void labelUpdate() { label4.Text = "Record " + (inc + 1) + " of " + MaxRows; } } }
  14. hai...everyone ... My problem is Whenever i start my laptop on the window it wil show " Unable to cast object of type 'System.Boolean' to type 'System.String'"this error...i donno anything about this pls...help me... thankq....
  15. hi....im getting this error "The remote procedure call failed.[0x800706be]".when i open sql server configuration manager.TCP\IP in enable.please help me..Thankq...
×
×
  • Create New...